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 ICX_CAT_BUILD_CTX_SQL_PVT

Line 9: g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

5:
6: -- Constants
7: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CTXSTRING_PVT';
8: g_metadataTblFormed BOOLEAN := FALSE;
9: g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
10: g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
11: g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
12:
13: -- populate Row with sequence: 1, 3, 6

Line 10: g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

6: -- Constants
7: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CTXSTRING_PVT';
8: g_metadataTblFormed BOOLEAN := FALSE;
9: g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
10: g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
11: g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
12:
13: -- populate Row with sequence: 1, 3, 6
14: -- Sequence 1 --> Mandatory Row

Line 11: g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

7: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CTXSTRING_PVT';
8: g_metadataTblFormed BOOLEAN := FALSE;
9: g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
10: g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
11: g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
12:
13: -- populate Row with sequence: 1, 3, 6
14: -- Sequence 1 --> Mandatory Row
15: -- Sequence 3 --> Internal Item Number

Line 22: p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

18: -- all data sources including master items
19: -- Values of p_repopulate_at_seq will be one among(1, 3, 6)
20: PROCEDURE popCtxBaseSpecAttForAllSrc
21: ( p_repopulate_at_seq IN NUMBER ,
22: p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
23: )
24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecAttForAllSrc';
26: l_err_loc PLS_INTEGER;

Line 29: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
32: l_csr_handle NUMBER;
33: l_status PLS_INTEGER;

Line 143: ( p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

139: -- populate Row with sequence: 2
140: -- Sequence 2 --> Supplier
141: -- No need to populate this row for Master items.
142: PROCEDURE popCtxBaseSpecSupplierAtt
143: ( p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
144: )
145: IS
146: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSupplierAtt';
147: l_err_loc PLS_INTEGER;

Line 150: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
153: l_csr_handle NUMBER;
154: l_status PLS_INTEGER;

Line 195: IF (ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow = l_sequence) THEN

191: l_ctx_sqlstring_rec := p_special_ctx_sql_tbl(i);
192: l_sequence := l_ctx_sqlstring_rec.bind_sequence;
193: l_ctx_sql_string := null;
194: l_err_loc := 900;
195: IF (ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow = l_sequence) THEN
196: l_err_loc := 1000;
197: l_ctx_sql_string := l_ctx_sqlstring_rec.ctx_sql_string;
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 275: p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type ,

271: -- Will not be populated for Master Items
272: -- Note: Calling procedure should take care of not calling this one with MASTER_ITEM source and sequence = 5
273: PROCEDURE popCtxBaseSpecSrcAndItemRevAtt
274: ( p_doc_source IN VARCHAR2 ,
275: p_special_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type ,
276: p_repopulate_at_seq IN NUMBER
277: )
278: IS
279: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseSpecSrcAndItemRevAtt';

Line 285: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
288: l_csr_handle NUMBER;
289: l_status PLS_INTEGER;

Line 466: p_regular_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type

462: -- Will be same for BPAs, Quotes, GBPAs and Req Templates
463: -- Only for master items, this will populate only the description.
464: PROCEDURE popCtxBaseRegularAttributes
465: ( p_doc_source IN VARCHAR2 ,
466: p_regular_ctx_sql_tbl IN ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type
467: )
468: IS
469: l_api_name CONSTANT VARCHAR2(30) := 'popCtxBaseRegularAttributes';
470: l_err_loc PLS_INTEGER;

Line 473: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
476: l_csr_handle NUMBER;
477: l_status PLS_INTEGER;

Line 587: AND dtls.sequence BETWEEN ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow

583: AND hdrs.req_template_name = dtls.req_template_name
584: AND hdrs.req_template_line_num = dtls.req_template_line_num
585: AND hdrs.language = dtls.language
586: AND hdrs.owning_org_id = dtls.org_id
587: AND dtls.sequence BETWEEN ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow
588: AND ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
589:
590: l_err_loc := 2300;
591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 588: AND ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;

584: AND hdrs.req_template_line_num = dtls.req_template_line_num
585: AND hdrs.language = dtls.language
586: AND hdrs.owning_org_id = dtls.org_id
587: AND dtls.sequence BETWEEN ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow
588: AND ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
589:
590: l_err_loc := 2300;
591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 649: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
653: l_err_loc PLS_INTEGER;

Line 650: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
653: l_err_loc PLS_INTEGER;
654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

Line 651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
653: l_err_loc PLS_INTEGER;
654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
655: l_csr_handle NUMBER;

Line 652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
653: l_err_loc PLS_INTEGER;
654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
655: l_csr_handle NUMBER;
656: l_status PLS_INTEGER;

Line 654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

650: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
651: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
652: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
653: l_err_loc PLS_INTEGER;
654: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
655: l_csr_handle NUMBER;
656: l_status PLS_INTEGER;
657: l_source_type1 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;
658: l_source_type2 icx_cat_items_ctx_hdrs_tlp.source_type%TYPE;

Line 669: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

665: ', p_internal_request_id:' || p_internal_request_id);
666: END IF;
667:
668: IF (NOT g_metadataTblFormed) THEN
669: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
670: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
671: g_metadataTblFormed := TRUE;
672: END IF;
673:

Line 675: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

671: g_metadataTblFormed := TRUE;
672: END IF;
673:
674: l_err_loc := 500;
675: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
676: (0, p_doc_source, 'ROWID', g_special_metadata_tbl,
677: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
678: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
679:

Line 821: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

Line 822: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;

Line 823: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

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;
824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;

Line 824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

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;
824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;
828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

Line 825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

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;
824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;
828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
829: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

Line 828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

824: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;
828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
829: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
830: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
831: l_start_catg_att_seq NUMBER;
832: l_end_catg_att_seq NUMBER;

Line 829: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

825: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;
828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
829: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
830: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
831: l_start_catg_att_seq NUMBER;
832: l_end_catg_att_seq NUMBER;
833: l_err_loc PLS_INTEGER;

Line 830: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

826: l_csr_handle NUMBER;
827: l_status PLS_INTEGER;
828: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
829: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
830: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
831: l_start_catg_att_seq NUMBER;
832: l_end_catg_att_seq NUMBER;
833: l_err_loc PLS_INTEGER;
834: l_start_date DATE;

Line 861: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

857: l_regular_tl_metadata_tbl.DELETE;
858: l_all_ctx_sql_tbl.DELETE;
859:
860: l_err_loc := 400;
861: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
862: (catgRec.rt_category_id, l_special_metadata_tbl,
863: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
864:
865: l_err_loc := 500;

Line 866: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

862: (catgRec.rt_category_id, l_special_metadata_tbl,
863: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
864:
865: l_err_loc := 500;
866: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
867: (catgRec.rt_category_id, NULL, 'ROWID', l_special_metadata_tbl,
868: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
869: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
870:

Line 952: l_start_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;

948: l_err_loc := 3000;
949: --populate category attributes For GLOBAL_BLANKET lines
950: --rows with sequence between 5001 and 9999 will be done here for GBPA rows
951: --loaded in the current internal_request_id
952: l_start_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
953: l_end_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
954: l_err_loc := 3100;
955: INSERT INTO icx_cat_items_ctx_dtls_tlp
956: (inventory_item_id, po_line_id, req_template_name,

Line 953: l_end_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;

949: --populate category attributes For GLOBAL_BLANKET lines
950: --rows with sequence between 5001 and 9999 will be done here for GBPA rows
951: --loaded in the current internal_request_id
952: l_start_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
953: l_end_catg_att_seq := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
954: l_err_loc := 3100;
955: INSERT INTO icx_cat_items_ctx_dtls_tlp
956: (inventory_item_id, po_line_id, req_template_name,
957: req_template_line_num, org_id, language,

Line 1142: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1138: )
1139: IS
1140: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxString';
1141: l_err_loc PLS_INTEGER;
1142: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1143: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1144: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1145: l_start_date DATE;
1146: l_end_date DATE;

Line 1143: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1139: IS
1140: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxString';
1141: l_err_loc PLS_INTEGER;
1142: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1143: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1144: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1145: l_start_date DATE;
1146: l_end_date DATE;
1147: l_log_string VARCHAR2(2000);

Line 1144: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1140: l_api_name CONSTANT VARCHAR2(30) := 'populateCtxString';
1141: l_err_loc PLS_INTEGER;
1142: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1143: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1144: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1145: l_start_date DATE;
1146: l_end_date DATE;
1147: l_log_string VARCHAR2(2000);
1148: BEGIN

Line 1260: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;

1256:
1257: l_err_loc := 600;
1258: IF (p_category_id > 0) THEN
1259: l_err_loc := 700;
1260: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
1261: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
1262: l_err_loc := 800;
1263: FORALL i IN 1..l_rowid_tbl.COUNT
1264: DELETE FROM icx_cat_items_ctx_dtls_tlp

Line 1261: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;

1257: l_err_loc := 600;
1258: IF (p_category_id > 0) THEN
1259: l_err_loc := 700;
1260: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartRegularCatgRow + 1;
1261: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndRegularCatgRow;
1262: l_err_loc := 800;
1263: FORALL i IN 1..l_rowid_tbl.COUNT
1264: DELETE FROM icx_cat_items_ctx_dtls_tlp
1265: WHERE po_line_id = l_po_line_id_tbl(i)

Line 1292: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;

1288: AND req_template_name = l_req_template_name_tbl(i)
1289: AND req_template_line_num = l_req_template_line_num_tbl(i)
1290: AND org_id = l_org_id_tbl(i)
1291: AND language = l_language_tbl(i)
1292: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
1293:
1294: l_err_loc := 1200;
1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1311: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;

1307: AND req_template_name = l_req_template_name_tbl(i)
1308: AND req_template_line_num = l_req_template_line_num_tbl(i)
1309: AND org_id = l_org_id_tbl(i)
1310: AND language = l_language_tbl(i)
1311: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
1312:
1313: l_err_loc := 1400;
1314: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1330: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow;

1326: AND req_template_name = l_req_template_name_tbl(i)
1327: AND req_template_line_num = l_req_template_line_num_tbl(i)
1328: AND org_id = l_org_id_tbl(i)
1329: AND language = l_language_tbl(i)
1330: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow;
1331:
1332: l_err_loc := 1600;
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1349: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow;

1345: AND req_template_name = l_req_template_name_tbl(i)
1346: AND req_template_line_num = l_req_template_line_num_tbl(i)
1347: AND org_id = l_org_id_tbl(i)
1348: AND language = l_language_tbl(i)
1349: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow;
1350:
1351: l_err_loc := 1800;
1352: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1368: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;

1364: AND req_template_name = l_req_template_name_tbl(i)
1365: AND req_template_line_num = l_req_template_line_num_tbl(i)
1366: AND org_id = l_org_id_tbl(i)
1367: AND language = l_language_tbl(i)
1368: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
1369:
1370: l_err_loc := 2000;
1371: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1372: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1387: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;

1383: AND req_template_name = l_req_template_name_tbl(i)
1384: AND req_template_line_num = l_req_template_line_num_tbl(i)
1385: AND org_id = l_org_id_tbl(i)
1386: AND language = l_language_tbl(i)
1387: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1388:
1389: l_err_loc := 2200;
1390: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 1398: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow + 1;

1394: END IF;
1395: ELSE
1396: l_err_loc := 2300;
1397: -- Delete the row with sequence between 100 and 5000 for re-populate
1398: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow + 1;
1399: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
1400: l_err_loc := 2400;
1401: FORALL i IN 1..l_rowid_tbl.COUNT
1402: DELETE FROM icx_cat_items_ctx_dtls_tlp

Line 1399: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;

1395: ELSE
1396: l_err_loc := 2300;
1397: -- Delete the row with sequence between 100 and 5000 for re-populate
1398: l_start_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqStartReqularBaseRow + 1;
1399: l_end_sequence := ICX_CAT_BUILD_CTX_SQL_PVT.g_seqEndReqularBaseRow;
1400: l_err_loc := 2400;
1401: FORALL i IN 1..l_rowid_tbl.COUNT
1402: DELETE FROM icx_cat_items_ctx_dtls_tlp
1403: WHERE po_line_id = l_po_line_id_tbl(i)

Line 1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

1535: )
1536: IS
1537: l_api_name CONSTANT VARCHAR2(30) := 'rePopulateBaseAttributes';
1538: l_err_loc PLS_INTEGER;
1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

1536: IS
1537: l_api_name CONSTANT VARCHAR2(30) := 'rePopulateBaseAttributes';
1538: l_err_loc PLS_INTEGER;
1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

1537: l_api_name CONSTANT VARCHAR2(30) := 'rePopulateBaseAttributes';
1538: l_err_loc PLS_INTEGER;
1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1545: l_internal_request_id NUMBER;

Line 1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1538: l_err_loc PLS_INTEGER;
1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1545: l_internal_request_id NUMBER;
1546: l_start_date DATE;

Line 1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1539: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1545: l_internal_request_id NUMBER;
1546: l_start_date DATE;
1547: l_end_date DATE;

Line 1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

1540: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1541: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
1542: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1543: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1544: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
1545: l_internal_request_id NUMBER;
1546: l_start_date DATE;
1547: l_end_date DATE;
1548: l_log_string VARCHAR2(2000);

Line 1591: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

1587:
1588: l_err_loc := 500;
1589: -- Need to insert the appropriate row/rows back into
1590: -- icx_cat_items_ctx_dtls_tlp depending upon the source and p_attribute_key
1591: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1592: (0, l_special_metadata_tbl, l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
1593:
1594: l_err_loc := 600;
1595: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

Line 1595: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

1591: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
1592: (0, l_special_metadata_tbl, l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
1593:
1594: l_err_loc := 600;
1595: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1596: (0, ICX_CAT_UTIL_PVT.g_PODoc_const, 'ROWID', l_special_metadata_tbl,
1597: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1598: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1599:

Line 1605: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow,

1601:
1602: IF (p_attribute_key IN ('SUPPLIER_PART_NUM', 'SUPPLIER_PART_AUXID')) THEN
1603: l_err_loc := 800;
1604: -- Row with sequence 1
1605: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow,
1606: l_special_ctx_sql_tbl);
1607: END IF;
1608:
1609: IF (p_searchable = 1 AND

Line 1622: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow,

1618: popCtxBaseSpecSupplierAtt(l_special_ctx_sql_tbl);
1619: ELSIF (p_attribute_key = 'INTERNAL_ITEM_NUM') THEN
1620: l_err_loc := 1100;
1621: -- Row with sequence 3
1622: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForInternalItemNumRow,
1623: l_special_ctx_sql_tbl);
1624: ELSIF (p_attribute_key IN ('SOURCE', 'ITEM_REVISION')) THEN
1625: l_err_loc := 1200;
1626: -- Row with sequence 4 (source) and 5 (Item Revision)

Line 1631: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);

1627: IF (p_attribute_key = 'SOURCE') THEN
1628: l_err_loc := 1300;
1629: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,
1630: l_special_ctx_sql_tbl,
1631: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1632: ELSE
1633: l_err_loc := 1400;
1634: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,
1635: l_special_ctx_sql_tbl,

Line 1636: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);

1632: ELSE
1633: l_err_loc := 1400;
1634: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_PODoc_const,
1635: l_special_ctx_sql_tbl,
1636: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);
1637: END IF;
1638:
1639: l_err_loc := 1500;
1640: l_all_ctx_sql_tbl.DELETE;

Line 1646: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

1642: l_regular_ctx_sql_tbl.DELETE;
1643:
1644: l_err_loc := 1600;
1645: -- Build the ctx sqls for Req templates.
1646: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1647: (0, ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const, 'ROWID', l_special_metadata_tbl,
1648: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1649: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1650: l_err_loc := 1700;

Line 1655: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);

1651: IF (p_attribute_key = 'SOURCE') THEN
1652: l_err_loc := 1800;
1653: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,
1654: l_special_ctx_sql_tbl,
1655: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSourceRow);
1656: ELSE
1657: l_err_loc := 1900;
1658: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,
1659: l_special_ctx_sql_tbl,

Line 1660: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);

1656: ELSE
1657: l_err_loc := 1900;
1658: popCtxBaseSpecSrcAndItemRevAtt(ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const,
1659: l_special_ctx_sql_tbl,
1660: ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow);
1661: END IF;
1662:
1663: l_err_loc := 2000;
1664: ELSIF (p_attribute_key = 'SHOPPING_CATEGORY') THEN

Line 1667: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow,

1663: l_err_loc := 2000;
1664: ELSIF (p_attribute_key = 'SHOPPING_CATEGORY') THEN
1665: l_err_loc := 2400;
1666: -- Row with sequence 6
1667: popCtxBaseSpecAttForAllSrc(ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow,
1668: l_special_ctx_sql_tbl);
1669: END IF;
1670: ELSE
1671: l_err_loc := 2500;

Line 1689: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

1685: l_regular_ctx_sql_tbl.DELETE;
1686:
1687: l_err_loc := 2800;
1688: -- Build the ctx_sql_table for Master Items
1689: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
1690: (0, ICX_CAT_UTIL_PVT.g_MasterItemCsr_const, 'ROWID', l_special_metadata_tbl,
1691: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
1692: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
1693: l_err_loc := 2900;

Line 1815: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble

1811: -- Update ctx_desc and internal_request_id for all items belonging to p_category_id and p_language in hdrs tlp
1812: l_internal_request_id := ICX_CAT_UTIL_PVT.getNextSequenceForWhoColumns;
1813:
1814: l_err_loc := 500;
1815: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble
1816: ('SHOPPING_CATEGORY', l_searchable, l_section_tag);
1817:
1818: l_err_loc := 600;
1819: OPEN l_csr_var FOR

Line 1867: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;

1863: AND req_template_name = l_req_template_name_tbl(i)
1864: AND req_template_line_num = l_req_template_line_num_tbl(i)
1865: AND org_id = l_org_id_tbl(i)
1866: AND language = l_language_tbl(i)
1867: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
1868:
1869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1871: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),