DBA Data[Home] [Help]

APPS.OKC_OLE_PVT dependencies on OKC_OPERATION_LINES_V

Line 408: p_token3_value => 'OKC_OPERATION_LINES_V');

404: p_token1_value => 'Operation Line Id',
405: p_token2 => g_child_table_token,
406: p_token2_value => G_VIEW,
407: p_token3 => g_parent_table_token,
408: p_token3_value => 'OKC_OPERATION_LINES_V');
409: -- notify caller of an error
410: x_return_status := OKC_API.G_RET_STS_ERROR;
411: End If;
412: End If;

Line 974: -- FUNCTION get_rec for: OKC_OPERATION_LINES_V

970: RETURN(get_rec(p_ole_rec, l_row_notfound));
971:
972: END get_rec;
973: ---------------------------------------------------------------------------
974: -- FUNCTION get_rec for: OKC_OPERATION_LINES_V
975: ---------------------------------------------------------------------------
976: FUNCTION get_rec (
977: p_olev_rec IN olev_rec_type,
978: x_no_data_found OUT NOCOPY BOOLEAN

Line 980: CURSOR okc_operation_lines_v_pk_csr (p_id IN NUMBER) IS

976: FUNCTION get_rec (
977: p_olev_rec IN olev_rec_type,
978: x_no_data_found OUT NOCOPY BOOLEAN
979: ) RETURN olev_rec_type IS
980: CURSOR okc_operation_lines_v_pk_csr (p_id IN NUMBER) IS
981: SELECT
982: ID,
983: SELECT_YN,
984: PROCESS_FLAG,

Line 1003: FROM Okc_Operation_Lines_V

999: PROGRAM_APPLICATION_ID,
1000: PROGRAM_ID,
1001: PROGRAM_UPDATE_DATE,
1002: MESSAGE_CODE
1003: FROM Okc_Operation_Lines_V
1004: WHERE okc_operation_lines_v.id = p_id;
1005: l_okc_operation_lines_v_pk okc_operation_lines_v_pk_csr%ROWTYPE;
1006: l_olev_rec olev_rec_type;
1007: BEGIN

Line 1004: WHERE okc_operation_lines_v.id = p_id;

1000: PROGRAM_ID,
1001: PROGRAM_UPDATE_DATE,
1002: MESSAGE_CODE
1003: FROM Okc_Operation_Lines_V
1004: WHERE okc_operation_lines_v.id = p_id;
1005: l_okc_operation_lines_v_pk okc_operation_lines_v_pk_csr%ROWTYPE;
1006: l_olev_rec olev_rec_type;
1007: BEGIN
1008:

Line 1005: l_okc_operation_lines_v_pk okc_operation_lines_v_pk_csr%ROWTYPE;

1001: PROGRAM_UPDATE_DATE,
1002: MESSAGE_CODE
1003: FROM Okc_Operation_Lines_V
1004: WHERE okc_operation_lines_v.id = p_id;
1005: l_okc_operation_lines_v_pk okc_operation_lines_v_pk_csr%ROWTYPE;
1006: l_olev_rec olev_rec_type;
1007: BEGIN
1008:
1009: IF (l_debug = 'Y') THEN

Line 1016: OPEN okc_operation_lines_v_pk_csr (p_olev_rec.id);

1012: END IF;
1013:
1014: x_no_data_found := TRUE;
1015: -- Get current database values
1016: OPEN okc_operation_lines_v_pk_csr (p_olev_rec.id);
1017: FETCH okc_operation_lines_v_pk_csr INTO
1018: l_olev_rec.ID,
1019: l_olev_rec.SELECT_YN,
1020: l_olev_rec.PROCESS_FLAG,

Line 1017: FETCH okc_operation_lines_v_pk_csr INTO

1013:
1014: x_no_data_found := TRUE;
1015: -- Get current database values
1016: OPEN okc_operation_lines_v_pk_csr (p_olev_rec.id);
1017: FETCH okc_operation_lines_v_pk_csr INTO
1018: l_olev_rec.ID,
1019: l_olev_rec.SELECT_YN,
1020: l_olev_rec.PROCESS_FLAG,
1021: l_olev_rec.ACTIVE_YN,

Line 1039: x_no_data_found := okc_operation_lines_v_pk_csr%NOTFOUND;

1035: l_olev_rec.PROGRAM_APPLICATION_ID,
1036: l_olev_rec.PROGRAM_ID,
1037: l_olev_rec.PROGRAM_UPDATE_DATE,
1038: l_olev_rec.MESSAGE_CODE;
1039: x_no_data_found := okc_operation_lines_v_pk_csr%NOTFOUND;
1040: CLOSE okc_operation_lines_v_pk_csr;
1041:
1042: IF (l_debug = 'Y') THEN
1043: okc_debug.log('4250: Leaving Fn Get_Rec ', 2);

Line 1040: CLOSE okc_operation_lines_v_pk_csr;

1036: l_olev_rec.PROGRAM_ID,
1037: l_olev_rec.PROGRAM_UPDATE_DATE,
1038: l_olev_rec.MESSAGE_CODE;
1039: x_no_data_found := okc_operation_lines_v_pk_csr%NOTFOUND;
1040: CLOSE okc_operation_lines_v_pk_csr;
1041:
1042: IF (l_debug = 'Y') THEN
1043: okc_debug.log('4250: Leaving Fn Get_Rec ', 2);
1044: okc_debug.Reset_Indentation;

Line 1062: -- FUNCTION null_out_defaults for: OKC_OPERATION_LINES_V --

1058:
1059: END get_rec;
1060:
1061: -----------------------------------------------------------
1062: -- FUNCTION null_out_defaults for: OKC_OPERATION_LINES_V --
1063: -----------------------------------------------------------
1064: FUNCTION null_out_defaults (
1065: p_olev_rec IN olev_rec_type
1066: ) RETURN olev_rec_type IS

Line 1147: -- Validate_Attributes for:OKC_OPERATION_LINES_V --

1143: ---------------------------------------------------------------------------
1144: -- PROCEDURE Validate_Attributes
1145: ---------------------------------------------------------------------------
1146: ---------------------------------------------------
1147: -- Validate_Attributes for:OKC_OPERATION_LINES_V --
1148: ---------------------------------------------------
1149: FUNCTION Validate_Attributes (
1150: p_olev_rec IN olev_rec_type
1151: ) RETURN VARCHAR2 IS

Line 1275: -- Validate_Record for:OKC_OPERATION_LINES_V --

1271: ---------------------------------------------------------------------------
1272: -- PROCEDURE Validate_Record
1273: ---------------------------------------------------------------------------
1274: -----------------------------------------------
1275: -- Validate_Record for:OKC_OPERATION_LINES_V --
1276: -----------------------------------------------
1277: FUNCTION Validate_Record (
1278: p_olev_rec IN olev_rec_type
1279: ) RETURN VARCHAR2 IS

Line 1354: -- validate_row for:OKC_OPERATION_LINES_V --

1350: ---------------------------------------------------------------------------
1351: -- PROCEDURE validate_row
1352: ---------------------------------------------------------------------------
1353: --------------------------------------------
1354: -- validate_row for:OKC_OPERATION_LINES_V --
1355: --------------------------------------------
1356: PROCEDURE validate_row(
1357: p_api_version IN NUMBER,
1358: p_init_msg_list IN VARCHAR2 ,

Line 1730: -- insert_row for:OKC_OPERATION_LINES_V --

1726: );
1727:
1728: END insert_row;
1729: ------------------------------------------
1730: -- insert_row for:OKC_OPERATION_LINES_V --
1731: ------------------------------------------
1732: PROCEDURE insert_row(
1733: p_api_version IN NUMBER,
1734: p_init_msg_list IN VARCHAR2 ,

Line 1766: -- Set_Attributes for:OKC_OPERATION_LINES_V --

1762: RETURN(l_olev_rec);
1763:
1764: END fill_who_columns;
1765: ----------------------------------------------
1766: -- Set_Attributes for:OKC_OPERATION_LINES_V --
1767: ----------------------------------------------
1768: FUNCTION Set_Attributes (
1769: p_olev_rec IN olev_rec_type,
1770: x_olev_rec OUT NOCOPY olev_rec_type

Line 2184: -- lock_row for:OKC_OPERATION_LINES_V --

2180: );
2181:
2182: END lock_row;
2183: ----------------------------------------
2184: -- lock_row for:OKC_OPERATION_LINES_V --
2185: ----------------------------------------
2186: PROCEDURE lock_row(
2187: p_api_version IN NUMBER,
2188: p_init_msg_list IN VARCHAR2 ,

Line 2666: -- update_row for:OKC_OPERATION_LINES_V --

2662: );
2663:
2664: END update_row;
2665: ------------------------------------------
2666: -- update_row for:OKC_OPERATION_LINES_V --
2667: ------------------------------------------
2668: PROCEDURE update_row(
2669: p_api_version IN NUMBER,
2670: p_init_msg_list IN VARCHAR2 ,

Line 2816: -- Set_Attributes for:OKC_OPERATION_LINES_V --

2812: RETURN(l_return_status);
2813:
2814: END populate_new_record;
2815: ----------------------------------------------
2816: -- Set_Attributes for:OKC_OPERATION_LINES_V --
2817: ----------------------------------------------
2818: FUNCTION Set_Attributes (
2819: p_olev_rec IN olev_rec_type,
2820: x_olev_rec OUT NOCOPY olev_rec_type

Line 3169: -- delete_row for:OKC_OPERATION_LINES_V --

3165: );
3166:
3167: END delete_row;
3168: ------------------------------------------
3169: -- delete_row for:OKC_OPERATION_LINES_V --
3170: ------------------------------------------
3171: PROCEDURE delete_row(
3172: p_api_version IN NUMBER,
3173: p_init_msg_list IN VARCHAR2 ,