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.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on DBMS_SQL

Line 27: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

23: )
24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecAttForAllSrc';
26: l_err_loc PLS_INTEGER;
27: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
28: l_csr_var g_csr_type;
29: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
30: l_ctx_sql_string VARCHAR2(4000) := NULL;
31: l_sequence NUMBER;

Line 89: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

85:
86: l_err_loc := 1100;
87: IF (l_ctx_sql_string IS NOT NULL) THEN
88: l_err_loc := 1200;
89: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
90: l_err_loc := 1300;
91: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
92: l_err_loc := 1400;
93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

Line 91: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);

87: IF (l_ctx_sql_string IS NOT NULL) THEN
88: l_err_loc := 1200;
89: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
90: l_err_loc := 1300;
91: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
92: l_err_loc := 1400;
93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
95: l_err_loc := 1500;

Line 93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

89: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
90: l_err_loc := 1300;
91: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
92: l_err_loc := 1400;
93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
95: l_err_loc := 1500;
96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;

Line 94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

90: l_err_loc := 1300;
91: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
92: l_err_loc := 1400;
93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
95: l_err_loc := 1500;
96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;
98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

92: l_err_loc := 1400;
93: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
95: l_err_loc := 1500;
96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;
98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
99: l_err_loc := 1700;
100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

94: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
95: l_err_loc := 1500;
96: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
97: l_err_loc := 1600;
98: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
99: l_err_loc := 1700;
100: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
101: l_err_loc := 1800;
102: COMMIT;

Line 148: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

144: )
145: IS
146: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSupplierAtt';
147: l_err_loc PLS_INTEGER;
148: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
149: l_csr_var g_csr_type;
150: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
151: l_ctx_sql_string VARCHAR2(4000) := NULL;
152: l_sequence NUMBER;

Line 211: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

207:
208: l_err_loc := 1100;
209: IF (l_ctx_sql_string IS NOT NULL) THEN
210: l_err_loc := 1200;
211: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
212: l_err_loc := 1300;
213: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
214: l_err_loc := 1400;
215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

Line 213: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);

209: IF (l_ctx_sql_string IS NOT NULL) THEN
210: l_err_loc := 1200;
211: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
212: l_err_loc := 1300;
213: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
214: l_err_loc := 1400;
215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
217: l_err_loc := 1500;

Line 215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

211: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
212: l_err_loc := 1300;
213: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
214: l_err_loc := 1400;
215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
217: l_err_loc := 1500;
218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;

Line 216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

212: l_err_loc := 1300;
213: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
214: l_err_loc := 1400;
215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
217: l_err_loc := 1500;
218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;
220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

214: l_err_loc := 1400;
215: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
217: l_err_loc := 1500;
218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;
220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
221: l_err_loc := 1700;
222: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

216: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
217: l_err_loc := 1500;
218: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
219: l_err_loc := 1600;
220: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
221: l_err_loc := 1700;
222: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
223: l_err_loc := 1800;
224: COMMIT;

Line 283: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

279: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSrcAndItemRevAtt';
280: l_err_loc PLS_INTEGER;
281: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
282: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
283: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
284: l_csr_var g_csr_type;
285: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
286: l_ctx_sql_string VARCHAR2(4000) := NULL;
287: l_sequence NUMBER;

Line 358: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

354:
355: l_err_loc := 1400;
356: IF (l_ctx_sql_string IS NOT NULL) THEN
357: l_err_loc := 1500;
358: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
359: l_err_loc := 1600;
360: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
361: l_err_loc := 1700;
362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

Line 360: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);

356: IF (l_ctx_sql_string IS NOT NULL) THEN
357: l_err_loc := 1500;
358: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
359: l_err_loc := 1600;
360: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
361: l_err_loc := 1700;
362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
364: l_err_loc := 1800;

Line 362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

358: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
359: l_err_loc := 1600;
360: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
361: l_err_loc := 1700;
362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
364: l_err_loc := 1800;
365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;

Line 363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

359: l_err_loc := 1600;
360: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
361: l_err_loc := 1700;
362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
364: l_err_loc := 1800;
365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;
367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

361: l_err_loc := 1700;
362: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
364: l_err_loc := 1800;
365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;
367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
368: l_err_loc := 2000;
369: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

363: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
364: l_err_loc := 1800;
365: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
366: l_err_loc := 1900;
367: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
368: l_err_loc := 2000;
369: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
370: l_err_loc := 2100;
371: COMMIT;

Line 471: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

467: )
468: IS
469: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseRegularAttributes';
470: l_err_loc PLS_INTEGER;
471: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
472: l_csr_var g_csr_type;
473: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
474: l_ctx_sql_string VARCHAR2(4000) := NULL;
475: l_sequence NUMBER;

Line 527: l_csr_handle :=DBMS_SQL.OPEN_CURSOR;

523: l_ctx_sqlstring_rec := p_regular_ctx_sql_tbl(i);
524: l_sequence := l_ctx_sqlstring_rec.bind_sequence;
525: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
526: l_err_loc := 1100;
527: l_csr_handle :=DBMS_SQL.OPEN_CURSOR;
528: l_err_loc := 1200;
529: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
530: l_err_loc := 1300;
531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

Line 529: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);

525: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
526: l_err_loc := 1100;
527: l_csr_handle :=DBMS_SQL.OPEN_CURSOR;
528: l_err_loc := 1200;
529: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
530: l_err_loc := 1300;
531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
533: l_err_loc := 1400;

Line 531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);

527: l_csr_handle :=DBMS_SQL.OPEN_CURSOR;
528: l_err_loc := 1200;
529: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
530: l_err_loc := 1300;
531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
533: l_err_loc := 1400;
534: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
535: l_err_loc := 1500;

Line 532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

528: l_err_loc := 1200;
529: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sql_string, DBMS_SQL.NATIVE);
530: l_err_loc := 1300;
531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
533: l_err_loc := 1400;
534: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
535: l_err_loc := 1500;
536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 534: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

530: l_err_loc := 1300;
531: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_sequence);
532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
533: l_err_loc := 1400;
534: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
535: l_err_loc := 1500;
536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
537: END LOOP;
538:

Line 536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

532: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
533: l_err_loc := 1400;
534: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
535: l_err_loc := 1500;
536: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
537: END LOOP;
538:
539: l_err_loc := 1600;
540: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 645: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

641: FROM icx_cat_items_ctx_hdrs_tlp
642: WHERE source_type IN (p_source_type1, p_source_type2)
643: AND internal_request_id = p_internal_request_id;
644:
645: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
646: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
647:
648: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxBaseAtt';
649: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 646: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;

642: WHERE source_type IN (p_source_type1, p_source_type2)
643: AND internal_request_id = p_internal_request_id;
644:
645: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
646: l_source_type_tbl DBMS_SQL.VARCHAR2_TABLE;
647:
648: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxBaseAtt';
649: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
650: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 736: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

732: FOR i IN 1..l_all_ctx_sql_tbl.COUNT LOOP
733: l_err_loc := 1900;
734: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
735: l_err_loc := 2000;
736: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
737: l_err_loc := 2100;
738: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
739: l_err_loc := 2200;
740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

Line 738: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);

734: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
735: l_err_loc := 2000;
736: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
737: l_err_loc := 2100;
738: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
739: l_err_loc := 2200;
740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
742: l_err_loc := 2300;

Line 740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

736: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
737: l_err_loc := 2100;
738: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
739: l_err_loc := 2200;
740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
742: l_err_loc := 2300;
743: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
744: l_err_loc := 2400;

Line 741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

737: l_err_loc := 2100;
738: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
739: l_err_loc := 2200;
740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
742: l_err_loc := 2300;
743: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
744: l_err_loc := 2400;
745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 743: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

739: l_err_loc := 2200;
740: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
742: l_err_loc := 2300;
743: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
744: l_err_loc := 2400;
745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
746: END LOOP;
747:

Line 745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

741: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
742: l_err_loc := 2300;
743: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
744: l_err_loc := 2400;
745: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
746: END LOOP;
747:
748: l_err_loc := 2500;
749: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 819: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

815: WHERE ip_category_id = p_category_id
816: AND internal_request_id = p_internal_request_id
817: AND source_type NOT IN ('MASTER ITEM', 'GLOBAL_BLANKET');
818:
819: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
820: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxCatgAtt';
821: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
822: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
823: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 907: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;

903: FOR i IN 1..l_all_ctx_sql_tbl.COUNT LOOP
904: l_err_loc := 1900;
905: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
906: l_err_loc := 2000;
907: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
908: l_err_loc := 2100;
909: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
910: l_err_loc := 2200;
911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

Line 909: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);

905: l_ctx_sqlstring_rec := l_all_ctx_sql_tbl(i);
906: l_err_loc := 2000;
907: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
908: l_err_loc := 2100;
909: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
910: l_err_loc := 2200;
911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
913: l_err_loc := 2300;

Line 911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);

907: l_csr_handle:=DBMS_SQL.OPEN_CURSOR;
908: l_err_loc := 2100;
909: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
910: l_err_loc := 2200;
911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
913: l_err_loc := 2300;
914: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
915: l_err_loc := 2400;

Line 912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);

908: l_err_loc := 2100;
909: DBMS_SQL.PARSE(l_csr_handle, l_ctx_sqlstring_rec.ctx_sql_string, DBMS_SQL.NATIVE);
910: l_err_loc := 2200;
911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
913: l_err_loc := 2300;
914: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
915: l_err_loc := 2400;
916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

Line 914: l_status := DBMS_SQL.EXECUTE(l_csr_handle);

910: l_err_loc := 2200;
911: DBMS_SQL.BIND_VARIABLE(l_csr_handle,':B_sequence', l_ctx_sqlstring_rec.bind_sequence);
912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
913: l_err_loc := 2300;
914: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
915: l_err_loc := 2400;
916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
917: END LOOP; -- l_all_ctx_sql_tbl LOOP
918:

Line 916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);

912: DBMS_SQL.BIND_ARRAY(l_csr_handle, ':B_rowid', l_rowid_tbl);
913: l_err_loc := 2300;
914: l_status := DBMS_SQL.EXECUTE(l_csr_handle);
915: l_err_loc := 2400;
916: DBMS_SQL.CLOSE_CURSOR(l_csr_handle);
917: END LOOP; -- l_all_ctx_sql_tbl LOOP
918:
919: l_err_loc := 2500;
920: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN

Line 1027: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

1023: SELECT rowid
1024: FROM icx_cat_items_ctx_hdrs_tlp
1025: WHERE internal_request_id = p_internal_request_id;
1026:
1027: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1028: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxOrgInfo';
1029: l_err_loc PLS_INTEGER;
1030: BEGIN
1031: l_err_loc := 100;

Line 1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

1196: l_api_name CONSTANT VARCHAR2(30) := 'updateItemsCtxHdrsTlp';
1197: l_err_loc PLS_INTEGER;
1198: l_internal_request_id NUMBER;
1199: l_csr_var g_csr_type;
1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

1197: l_err_loc PLS_INTEGER;
1198: l_internal_request_id NUMBER;
1199: l_csr_var g_csr_type;
1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1198: l_internal_request_id NUMBER;
1199: l_csr_var g_csr_type;
1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

1199: l_csr_var g_csr_type;
1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_start_sequence NUMBER;

Line 1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

1200: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_start_sequence NUMBER;
1208: l_end_sequence NUMBER;

Line 1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1201: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_start_sequence NUMBER;
1208: l_end_sequence NUMBER;
1209: l_err_string VARCHAR2(4000);

Line 1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1202: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1203: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1204: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1205: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1206: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1207: l_start_sequence NUMBER;
1208: l_end_sequence NUMBER;
1209: l_err_string VARCHAR2(4000);
1210:

Line 1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;

1780: l_internal_request_id NUMBER;
1781: l_searchable NUMBER;
1782: l_section_tag NUMBER;
1783: l_csr_var g_csr_type;
1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;

1781: l_searchable NUMBER;
1782: l_section_tag NUMBER;
1783: l_csr_var g_csr_type;
1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

1782: l_section_tag NUMBER;
1783: l_csr_var g_csr_type;
1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

1783: l_csr_var g_csr_type;
1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1791: l_err_string VARCHAR2(4000);

Line 1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;

1784: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1791: l_err_string VARCHAR2(4000);
1792: l_start_date DATE;

Line 1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

1785: l_po_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1791: l_err_string VARCHAR2(4000);
1792: l_start_date DATE;
1793: l_end_date DATE;

Line 1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

1786: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
1787: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;
1788: l_req_template_line_num_tbl DBMS_SQL.NUMBER_TABLE;
1789: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
1790: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
1791: l_err_string VARCHAR2(4000);
1792: l_start_date DATE;
1793: l_end_date DATE;
1794: l_log_string VARCHAR2(2000);