eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OLE_PVT dependencies on OKC_OPERATION_LINES

Line 379: from OKC_OPERATION_LINES

375:
376: l_dummy_var VARCHAR2(1) := '?';
377: Cursor l_olev_csr Is
378: select 'x'
379: from OKC_OPERATION_LINES
380: where id = p_olev_rec.parent_ole_id;
381:
382: Begin
383:

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 841: SELECT OKC_OPERATION_LINES_S1.nextval

837: -- FUNCTION get_seq_id
838: ---------------------------------------------------------------------------
839: FUNCTION get_seq_id RETURN NUMBER IS
840: Cursor c Is
841: SELECT OKC_OPERATION_LINES_S1.nextval
842: FROM dual;
843:
844: l_seq NUMBER;
845: BEGIN

Line 887: -- FUNCTION get_rec for: OKC_OPERATION_LINES

883:
884: END api_copy;
885:
886: ---------------------------------------------------------------------------
887: -- FUNCTION get_rec for: OKC_OPERATION_LINES
888: ---------------------------------------------------------------------------
889: FUNCTION get_rec (
890: p_ole_rec IN ole_rec_type,
891: x_no_data_found OUT NOCOPY BOOLEAN

Line 893: CURSOR okc_operation_lines_pk_csr (p_id IN NUMBER) IS

889: FUNCTION get_rec (
890: p_ole_rec IN ole_rec_type,
891: x_no_data_found OUT NOCOPY BOOLEAN
892: ) RETURN ole_rec_type IS
893: CURSOR okc_operation_lines_pk_csr (p_id IN NUMBER) IS
894: SELECT
895: ID,
896: SELECT_YN,
897: PROCESS_FLAG,

Line 916: FROM Okc_Operation_Lines

912: PROGRAM_APPLICATION_ID,
913: PROGRAM_ID,
914: PROGRAM_UPDATE_DATE,
915: MESSAGE_CODE
916: FROM Okc_Operation_Lines
917: WHERE okc_operation_lines.id = p_id;
918: l_okc_operation_lines_pk okc_operation_lines_pk_csr%ROWTYPE;
919: l_ole_rec ole_rec_type;
920: BEGIN

Line 917: WHERE okc_operation_lines.id = p_id;

913: PROGRAM_ID,
914: PROGRAM_UPDATE_DATE,
915: MESSAGE_CODE
916: FROM Okc_Operation_Lines
917: WHERE okc_operation_lines.id = p_id;
918: l_okc_operation_lines_pk okc_operation_lines_pk_csr%ROWTYPE;
919: l_ole_rec ole_rec_type;
920: BEGIN
921:

Line 918: l_okc_operation_lines_pk okc_operation_lines_pk_csr%ROWTYPE;

914: PROGRAM_UPDATE_DATE,
915: MESSAGE_CODE
916: FROM Okc_Operation_Lines
917: WHERE okc_operation_lines.id = p_id;
918: l_okc_operation_lines_pk okc_operation_lines_pk_csr%ROWTYPE;
919: l_ole_rec ole_rec_type;
920: BEGIN
921:
922: IF (l_debug = 'Y') THEN

Line 929: OPEN okc_operation_lines_pk_csr (p_ole_rec.id);

925: END IF;
926:
927: x_no_data_found := TRUE;
928: -- Get current database values
929: OPEN okc_operation_lines_pk_csr (p_ole_rec.id);
930: FETCH okc_operation_lines_pk_csr INTO
931: l_ole_rec.ID,
932: l_ole_rec.SELECT_YN,
933: l_ole_rec.PROCESS_FLAG,

Line 930: FETCH okc_operation_lines_pk_csr INTO

926:
927: x_no_data_found := TRUE;
928: -- Get current database values
929: OPEN okc_operation_lines_pk_csr (p_ole_rec.id);
930: FETCH okc_operation_lines_pk_csr INTO
931: l_ole_rec.ID,
932: l_ole_rec.SELECT_YN,
933: l_ole_rec.PROCESS_FLAG,
934: l_ole_rec.ACTIVE_YN,

Line 952: x_no_data_found := okc_operation_lines_pk_csr%NOTFOUND;

948: l_ole_rec.PROGRAM_APPLICATION_ID,
949: l_ole_rec.PROGRAM_ID,
950: l_ole_rec.PROGRAM_UPDATE_DATE,
951: l_ole_rec.MESSAGE_CODE;
952: x_no_data_found := okc_operation_lines_pk_csr%NOTFOUND;
953: CLOSE okc_operation_lines_pk_csr;
954:
955: IF (l_debug = 'Y') THEN
956: okc_debug.log('4050: Leaving Fn Get_Rec ', 2);

Line 953: CLOSE okc_operation_lines_pk_csr;

949: l_ole_rec.PROGRAM_ID,
950: l_ole_rec.PROGRAM_UPDATE_DATE,
951: l_ole_rec.MESSAGE_CODE;
952: x_no_data_found := okc_operation_lines_pk_csr%NOTFOUND;
953: CLOSE okc_operation_lines_pk_csr;
954:
955: IF (l_debug = 'Y') THEN
956: okc_debug.log('4050: Leaving Fn Get_Rec ', 2);
957: okc_debug.Reset_Indentation;

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 1570: -- insert_row for:OKC_OPERATION_LINES --

1566: ---------------------------------------------------------------------------
1567: -- PROCEDURE insert_row
1568: ---------------------------------------------------------------------------
1569: ----------------------------------------
1570: -- insert_row for:OKC_OPERATION_LINES --
1571: ----------------------------------------
1572: PROCEDURE insert_row(
1573: p_init_msg_list IN VARCHAR2 ,
1574: x_return_status OUT NOCOPY VARCHAR2,

Line 1586: -- Set_Attributes for:OKC_OPERATION_LINES --

1582: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1583: l_ole_rec ole_rec_type := p_ole_rec;
1584: l_def_ole_rec ole_rec_type;
1585: --------------------------------------------
1586: -- Set_Attributes for:OKC_OPERATION_LINES --
1587: --------------------------------------------
1588: FUNCTION Set_Attributes (
1589: p_ole_rec IN ole_rec_type,
1590: x_ole_rec OUT NOCOPY ole_rec_type

Line 1625: INSERT INTO OKC_OPERATION_LINES(

1621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1623: RAISE OKC_API.G_EXCEPTION_ERROR;
1624: END IF;
1625: INSERT INTO OKC_OPERATION_LINES(
1626: id,
1627: select_yn,
1628: process_flag,
1629: active_yn,

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 2024: -- lock_row for:OKC_OPERATION_LINES --

2020: ---------------------------------------------------------------------------
2021: -- PROCEDURE lock_row
2022: ---------------------------------------------------------------------------
2023: --------------------------------------
2024: -- lock_row for:OKC_OPERATION_LINES --
2025: --------------------------------------
2026: PROCEDURE lock_row(
2027: p_init_msg_list IN VARCHAR2 ,
2028: x_return_status OUT NOCOPY VARCHAR2,

Line 2037: FROM OKC_OPERATION_LINES

2033: E_Resource_Busy EXCEPTION;
2034: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2035: CURSOR lock_csr (p_ole_rec IN ole_rec_type) IS
2036: SELECT OBJECT_VERSION_NUMBER
2037: FROM OKC_OPERATION_LINES
2038: WHERE ID = p_ole_rec.id
2039: AND OBJECT_VERSION_NUMBER = p_ole_rec.object_version_number
2040: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2041:

Line 2044: FROM OKC_OPERATION_LINES

2040: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2041:
2042: CURSOR lchk_csr (p_ole_rec IN ole_rec_type) IS
2043: SELECT OBJECT_VERSION_NUMBER
2044: FROM OKC_OPERATION_LINES
2045: WHERE ID = p_ole_rec.id;
2046: l_api_version CONSTANT NUMBER := 1;
2047: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2049: l_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;

2045: WHERE ID = p_ole_rec.id;
2046: l_api_version CONSTANT NUMBER := 1;
2047: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2049: l_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;
2050: lc_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;
2051: l_row_notfound BOOLEAN := FALSE;
2052: lc_row_notfound BOOLEAN := FALSE;
2053: BEGIN

Line 2050: lc_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;

2046: l_api_version CONSTANT NUMBER := 1;
2047: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2048: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2049: l_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;
2050: lc_object_version_number OKC_OPERATION_LINES.OBJECT_VERSION_NUMBER%TYPE;
2051: l_row_notfound BOOLEAN := FALSE;
2052: lc_row_notfound BOOLEAN := FALSE;
2053: BEGIN
2054:

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 2405: -- update_row for:OKC_OPERATION_LINES --

2401: ---------------------------------------------------------------------------
2402: -- PROCEDURE update_row
2403: ---------------------------------------------------------------------------
2404: ----------------------------------------
2405: -- update_row for:OKC_OPERATION_LINES --
2406: ----------------------------------------
2407: PROCEDURE update_row(
2408: p_init_msg_list IN VARCHAR2 ,
2409: x_return_status OUT NOCOPY VARCHAR2,

Line 2538: -- Set_Attributes for:OKC_OPERATION_LINES --

2534: RETURN(l_return_status);
2535:
2536: END populate_new_record;
2537: --------------------------------------------
2538: -- Set_Attributes for:OKC_OPERATION_LINES --
2539: --------------------------------------------
2540: FUNCTION Set_Attributes (
2541: p_ole_rec IN ole_rec_type,
2542: x_ole_rec OUT NOCOPY ole_rec_type

Line 2583: UPDATE OKC_OPERATION_LINES

2579: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2580: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2581: RAISE OKC_API.G_EXCEPTION_ERROR;
2582: END IF;
2583: UPDATE OKC_OPERATION_LINES
2584: SET SELECT_YN = l_def_ole_rec.select_yn,
2585: PROCESS_FLAG = l_def_ole_rec.process_flag,
2586: ACTIVE_YN = l_def_ole_rec.active_yn,
2587: OIE_ID = l_def_ole_rec.oie_id,

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 3077: -- delete_row for:OKC_OPERATION_LINES --

3073: ---------------------------------------------------------------------------
3074: -- PROCEDURE delete_row
3075: ---------------------------------------------------------------------------
3076: ----------------------------------------
3077: -- delete_row for:OKC_OPERATION_LINES --
3078: ----------------------------------------
3079: PROCEDURE delete_row(
3080: p_init_msg_list IN VARCHAR2 ,
3081: x_return_status OUT NOCOPY VARCHAR2,

Line 3107: DELETE FROM OKC_OPERATION_LINES

3103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3105: RAISE OKC_API.G_EXCEPTION_ERROR;
3106: END IF;
3107: DELETE FROM OKC_OPERATION_LINES
3108: WHERE ID = l_ole_rec.id;
3109:
3110: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3111:

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 ,