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_AST_PVT dependencies on OKC_ASSENTS

Line 16: OKC_ASSENTS_V

12: cursor seed_c is
13: select
14: nvl(max(id), 11000) + 1
15: from
16: OKC_ASSENTS_V
17: where
18: id >= 11000 AND id < 50000;
19: BEGIN
20: if fnd_global.user_id = 1 then

Line 55: -- FUNCTION get_rec for: OKC_ASSENTS

51: null;
52: END api_copy;
53:
54: ---------------------------------------------------------------------------
55: -- FUNCTION get_rec for: OKC_ASSENTS
56: ---------------------------------------------------------------------------
57: FUNCTION get_rec (
58: p_ast_rec IN ast_rec_type,
59: x_no_data_found OUT NOCOPY BOOLEAN

Line 91: FROM Okc_Assents

87: ATTRIBUTE12,
88: ATTRIBUTE13,
89: ATTRIBUTE14,
90: ATTRIBUTE15
91: FROM Okc_Assents
92: WHERE okc_assents.id = p_id;
93: l_ast_pk ast_pk_csr%ROWTYPE;
94: l_ast_rec ast_rec_type;
95: BEGIN

Line 92: WHERE okc_assents.id = p_id;

88: ATTRIBUTE13,
89: ATTRIBUTE14,
90: ATTRIBUTE15
91: FROM Okc_Assents
92: WHERE okc_assents.id = p_id;
93: l_ast_pk ast_pk_csr%ROWTYPE;
94: l_ast_rec ast_rec_type;
95: BEGIN
96: x_no_data_found := TRUE;

Line 141: -- FUNCTION get_rec for: OKC_ASSENTS_V

137: BEGIN
138: RETURN(get_rec(p_ast_rec, l_row_notfound));
139: END get_rec;
140: ---------------------------------------------------------------------------
141: -- FUNCTION get_rec for: OKC_ASSENTS_V
142: ---------------------------------------------------------------------------
143: FUNCTION get_rec (
144: p_astv_rec IN astv_rec_type,
145: x_no_data_found OUT NOCOPY BOOLEAN

Line 177: FROM Okc_Assents_V

173: CREATION_DATE,
174: LAST_UPDATED_BY,
175: LAST_UPDATE_DATE,
176: LAST_UPDATE_LOGIN
177: FROM Okc_Assents_V
178: WHERE okc_assents_v.id = p_id;
179: l_okc_astv_pk okc_astv_pk_csr%ROWTYPE;
180: l_astv_rec astv_rec_type;
181: BEGIN

Line 178: WHERE okc_assents_v.id = p_id;

174: LAST_UPDATED_BY,
175: LAST_UPDATE_DATE,
176: LAST_UPDATE_LOGIN
177: FROM Okc_Assents_V
178: WHERE okc_assents_v.id = p_id;
179: l_okc_astv_pk okc_astv_pk_csr%ROWTYPE;
180: l_astv_rec astv_rec_type;
181: BEGIN
182: x_no_data_found := TRUE;

Line 228: -- FUNCTION null_out_defaults for: OKC_ASSENTS_V --

224: RETURN(get_rec(p_astv_rec, l_row_notfound));
225: END get_rec;
226:
227: ---------------------------------------------------
228: -- FUNCTION null_out_defaults for: OKC_ASSENTS_V --
229: ---------------------------------------------------
230: FUNCTION null_out_defaults (
231: p_astv_rec IN astv_rec_type
232: ) RETURN astv_rec_type IS

Line 503: -- Validate_Attributes for:OKC_ASSENTS_V --

499: ---------------------------------------------------------------------------
500: -- PROCEDURE Validate_Attributes
501: ---------------------------------------------------------------------------
502: -------------------------------------------
503: -- Validate_Attributes for:OKC_ASSENTS_V --
504: -------------------------------------------
505: FUNCTION Validate_Attributes (
506: p_astv_rec IN astv_rec_type
507: ) RETURN VARCHAR2 IS

Line 605: -- Validate_Record for:OKC_ASSENTS_V --

601: ---------------------------------------------------------------------------
602: -- PROCEDURE Validate_Record
603: ---------------------------------------------------------------------------
604: ---------------------------------------
605: -- Validate_Record for:OKC_ASSENTS_V --
606: ---------------------------------------
607: FUNCTION Validate_Record (
608: p_astv_rec IN astv_rec_type
609: ) RETURN VARCHAR2 IS

Line 688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,

684: unique_key_error EXCEPTION;
685: l_dummy VARCHAR2(1);
686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS

Line 689: p_scs_code IN okc_assents_v.scs_code%TYPE,

685: l_dummy VARCHAR2(1);
686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'

Line 690: p_sts_code IN okc_assents_v.sts_code%TYPE,

686: l_row_found BOOLEAN;
687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V

Line 691: p_opn_code IN okc_assents_v.opn_code%TYPE,

687: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code

Line 692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS

688: CURSOR c1 (p_id IN okc_assents_v.id%TYPE,
689: p_scs_code IN okc_assents_v.scs_code%TYPE,
690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code
696: AND sts_code = p_sts_code

Line 694: FROM Okc_Assents_V

690: p_sts_code IN okc_assents_v.sts_code%TYPE,
691: p_opn_code IN okc_assents_v.opn_code%TYPE,
692: p_ste_code IN okc_assents_v.ste_code%TYPE) IS
693: SELECT 'x'
694: FROM Okc_Assents_V
695: WHERE scs_code = p_scs_code
696: AND sts_code = p_sts_code
697: AND opn_code = p_opn_code
698: AND ste_code = p_ste_code

Line 825: -- validate_row for:OKC_ASSENTS_V --

821: ---------------------------------------------------------------------------
822: -- PROCEDURE validate_row
823: ---------------------------------------------------------------------------
824: ------------------------------------
825: -- validate_row for:OKC_ASSENTS_V --
826: ------------------------------------
827: PROCEDURE validate_row(
828: p_api_version IN NUMBER,
829: p_init_msg_list IN VARCHAR2 ,

Line 969: -- insert_row for:OKC_ASSENTS --

965: ---------------------------------------------------------------------------
966: -- PROCEDURE insert_row
967: ---------------------------------------------------------------------------
968: --------------------------------
969: -- insert_row for:OKC_ASSENTS --
970: --------------------------------
971: PROCEDURE insert_row(
972: p_init_msg_list IN VARCHAR2 ,
973: x_return_status OUT NOCOPY VARCHAR2,

Line 985: -- Set_Attributes for:OKC_ASSENTS --

981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
982: l_ast_rec ast_rec_type := p_ast_rec;
983: l_def_ast_rec ast_rec_type;
984: ------------------------------------
985: -- Set_Attributes for:OKC_ASSENTS --
986: ------------------------------------
987: FUNCTION Set_Attributes (
988: p_ast_rec IN ast_rec_type,
989: x_ast_rec OUT NOCOPY ast_rec_type

Line 1016: INSERT INTO OKC_ASSENTS(

1012: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1014: RAISE OKC_API.G_EXCEPTION_ERROR;
1015: END IF;
1016: INSERT INTO OKC_ASSENTS(
1017: id,
1018: sts_code,
1019: opn_code,
1020: ste_code,

Line 1110: -- insert_row for:OKC_ASSENTS_V --

1106: '_PVT'
1107: );
1108: END insert_row;
1109: ----------------------------------
1110: -- insert_row for:OKC_ASSENTS_V --
1111: ----------------------------------
1112: PROCEDURE insert_row(
1113: p_api_version IN NUMBER,
1114: p_init_msg_list IN VARCHAR2 ,

Line 1144: -- Set_Attributes for:OKC_ASSENTS_V --

1140: l_astv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1141: RETURN(l_astv_rec);
1142: END fill_who_columns;
1143: --------------------------------------
1144: -- Set_Attributes for:OKC_ASSENTS_V --
1145: --------------------------------------
1146: FUNCTION Set_Attributes (
1147: p_astv_rec IN astv_rec_type,
1148: x_astv_rec OUT NOCOPY astv_rec_type

Line 1324: -- lock_row for:OKC_ASSENTS --

1320: ---------------------------------------------------------------------------
1321: -- PROCEDURE lock_row
1322: ---------------------------------------------------------------------------
1323: ------------------------------
1324: -- lock_row for:OKC_ASSENTS --
1325: ------------------------------
1326: PROCEDURE lock_row(
1327: p_init_msg_list IN VARCHAR2 ,
1328: x_return_status OUT NOCOPY VARCHAR2,

Line 1337: FROM OKC_ASSENTS

1333: E_Resource_Busy EXCEPTION;
1334: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1335: CURSOR lock_csr (p_ast_rec IN ast_rec_type) IS
1336: SELECT OBJECT_VERSION_NUMBER
1337: FROM OKC_ASSENTS
1338: WHERE ID = p_ast_rec.id
1339: AND OBJECT_VERSION_NUMBER = p_ast_rec.object_version_number
1340: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1341:

Line 1344: FROM OKC_ASSENTS

1340: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1341:
1342: CURSOR lchk_csr (p_ast_rec IN ast_rec_type) IS
1343: SELECT OBJECT_VERSION_NUMBER
1344: FROM OKC_ASSENTS
1345: WHERE ID = p_ast_rec.id;
1346: l_api_version CONSTANT NUMBER := 1;
1347: l_api_name CONSTANT VARCHAR2(30) := 'ASSENTS_lock_row';
1348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1349: l_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;

1345: WHERE ID = p_ast_rec.id;
1346: l_api_version CONSTANT NUMBER := 1;
1347: l_api_name CONSTANT VARCHAR2(30) := 'ASSENTS_lock_row';
1348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1349: l_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;
1350: lc_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;
1351: l_row_notfound BOOLEAN := FALSE;
1352: lc_row_notfound BOOLEAN := FALSE;
1353: BEGIN

Line 1350: lc_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;

1346: l_api_version CONSTANT NUMBER := 1;
1347: l_api_name CONSTANT VARCHAR2(30) := 'ASSENTS_lock_row';
1348: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1349: l_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;
1350: lc_object_version_number OKC_ASSENTS.OBJECT_VERSION_NUMBER%TYPE;
1351: l_row_notfound BOOLEAN := FALSE;
1352: lc_row_notfound BOOLEAN := FALSE;
1353: BEGIN
1354: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1430: -- lock_row for:OKC_ASSENTS_V --

1426: '_PVT'
1427: );
1428: END lock_row;
1429: --------------------------------
1430: -- lock_row for:OKC_ASSENTS_V --
1431: --------------------------------
1432: PROCEDURE lock_row(
1433: p_api_version IN NUMBER,
1434: p_init_msg_list IN VARCHAR2 ,

Line 1578: -- update_row for:OKC_ASSENTS --

1574: ---------------------------------------------------------------------------
1575: -- PROCEDURE update_row
1576: ---------------------------------------------------------------------------
1577: --------------------------------
1578: -- update_row for:OKC_ASSENTS --
1579: --------------------------------
1580: PROCEDURE update_row(
1581: p_init_msg_list IN VARCHAR2 ,
1582: x_return_status OUT NOCOPY VARCHAR2,

Line 1726: -- Set_Attributes for:OKC_ASSENTS --

1722: END IF;
1723: RETURN(l_return_status);
1724: END populate_new_record;
1725: ------------------------------------
1726: -- Set_Attributes for:OKC_ASSENTS --
1727: ------------------------------------
1728: FUNCTION Set_Attributes (
1729: p_ast_rec IN ast_rec_type,
1730: x_ast_rec OUT NOCOPY ast_rec_type

Line 1763: UPDATE OKC_ASSENTS

1759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1760: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1761: RAISE OKC_API.G_EXCEPTION_ERROR;
1762: END IF;
1763: UPDATE OKC_ASSENTS
1764: SET STS_CODE = l_def_ast_rec.sts_code,
1765: OPN_CODE = l_def_ast_rec.opn_code,
1766: STE_CODE = l_def_ast_rec.ste_code,
1767: SCS_CODE = l_def_ast_rec.scs_code,

Line 1828: -- update_row for:OKC_ASSENTS_V --

1824: '_PVT'
1825: );
1826: END update_row;
1827: ----------------------------------
1828: -- update_row for:OKC_ASSENTS_V --
1829: ----------------------------------
1830: PROCEDURE update_row(
1831: p_api_version IN NUMBER,
1832: p_init_msg_list IN VARCHAR2 ,

Line 1991: -- Set_Attributes for:OKC_ASSENTS_V --

1987: END IF;
1988: RETURN(l_return_status);
1989: END populate_new_record;
1990: --------------------------------------
1991: -- Set_Attributes for:OKC_ASSENTS_V --
1992: --------------------------------------
1993: FUNCTION Set_Attributes (
1994: p_astv_rec IN astv_rec_type,
1995: x_astv_rec OUT NOCOPY astv_rec_type

Line 2174: -- delete_row for:OKC_ASSENTS --

2170: ---------------------------------------------------------------------------
2171: -- PROCEDURE delete_row
2172: ---------------------------------------------------------------------------
2173: --------------------------------
2174: -- delete_row for:OKC_ASSENTS --
2175: --------------------------------
2176: PROCEDURE delete_row(
2177: p_init_msg_list IN VARCHAR2 ,
2178: x_return_status OUT NOCOPY VARCHAR2,

Line 2198: DELETE FROM OKC_ASSENTS

2194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2196: RAISE OKC_API.G_EXCEPTION_ERROR;
2197: END IF;
2198: DELETE FROM OKC_ASSENTS
2199: WHERE ID = l_ast_rec.id;
2200:
2201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2202: EXCEPTION

Line 2235: -- delete_row for:OKC_ASSENTS_V --

2231: '_PVT'
2232: );
2233: END delete_row;
2234: ----------------------------------
2235: -- delete_row for:OKC_ASSENTS_V --
2236: ----------------------------------
2237: PROCEDURE delete_row(
2238: p_api_version IN NUMBER,
2239: p_init_msg_list IN VARCHAR2 ,

Line 2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is

2406: from okc_k_headers_all_b
2407: --END NPALEPU
2408: where id = p_header_id;
2409: --
2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2411: select 'x'
2412: from okc_assents
2413: where scs_code = l_scs_code
2414: and sts_code = l_sts_code

Line 2412: from okc_assents

2408: where id = p_header_id;
2409: --
2410: cursor ast_csr (p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2411: select 'x'
2412: from okc_assents
2413: where scs_code = l_scs_code
2414: and sts_code = l_sts_code
2415: and opn_code = p_opn_code
2416: and allowed_yn = p_allowed_yn;

Line 2559: cursor c1(p_allowed_yn okc_assents_v.allowed_yn%TYPE) is

2555: l_dummy varchar2(1);
2556: l_row_notfound BOOLEAN;
2557: l_return_status Varchar2(1);
2558: l_lse_id okc_k_lines_v.lse_id%TYPE;
2559: cursor c1(p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2560: select 'x'
2561: from okc_k_lines_b L,
2562: --NPALEPU for Bug # 4597099 on 13-AUG-2005
2563: /* okc_k_headers_b K, */

Line 2566: okc_assents A

2562: --NPALEPU for Bug # 4597099 on 13-AUG-2005
2563: /* okc_k_headers_b K, */
2564: OKC_K_HEADERS_ALL_B K,
2565: --END NPALEPU
2566: okc_assents A
2567: where L.ID = p_line_id
2568: and L.DNZ_CHR_ID = K.ID
2569: and A.SCS_CODE = K.SCS_CODE
2570: and A.STS_CODE = L.STS_CODE