DBA Data[Home] [Help]

APPS.PO_DOC_NUMBERING_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),

94: END IF;
95:
96: IF p_caller = 'REQ' OR p_caller = 'SOL' OR p_caller = 'SOL_AMD' THEN
97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
102: po_moac_utils_pvt.get_current_org_id*/

Line 99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),

95:
96: IF p_caller = 'REQ' OR p_caller = 'SOL' OR p_caller = 'SOL_AMD' THEN
97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
102: po_moac_utils_pvt.get_current_org_id*/
103: );

Line 100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))

96: IF p_caller = 'REQ' OR p_caller = 'SOL' OR p_caller = 'SOL_AMD' THEN
97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
102: po_moac_utils_pvt.get_current_org_id*/
103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN

Line 106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),

102: po_moac_utils_pvt.get_current_org_id*/
103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
109: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
110: po_moac_utils_pvt.get_current_org_id*/

Line 107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),

103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
109: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
110: po_moac_utils_pvt.get_current_org_id*/
111: );

Line 108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))

104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
109: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
110: po_moac_utils_pvt.get_current_org_id*/
111: );
112: END IF;

Line 215: EGO_COL_NAME_VALUE_PAIR_OBJ(

211: l_ag_type := 'PO_HEADER_EXT_ATTRS';
212: l_src_data_level := 'PO_HEADER';
213:
214: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
215: EGO_COL_NAME_VALUE_PAIR_OBJ(
216: 'PO_HEADER_ID', p_doc_header_id
217: ),
218: EGO_COL_NAME_VALUE_PAIR_OBJ(
219: 'DRAFT_ID', p_draft_id

Line 218: EGO_COL_NAME_VALUE_PAIR_OBJ(

214: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
215: EGO_COL_NAME_VALUE_PAIR_OBJ(
216: 'PO_HEADER_ID', p_doc_header_id
217: ),
218: EGO_COL_NAME_VALUE_PAIR_OBJ(
219: 'DRAFT_ID', p_draft_id
220: )
221: );
222:

Line 229: EGO_COL_NAME_VALUE_PAIR_OBJ(

225: l_ag_type := 'PON_AUC_HDRS_EXT_ATTRS';
226: l_src_data_level := 'PON_AUC_HEADER';
227:
228: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
229: EGO_COL_NAME_VALUE_PAIR_OBJ(
230: 'AUCTION_HEADER_ID', p_doc_header_id
231: )
232: );
233: END IF;

Line 308: EGO_COL_NAME_VALUE_PAIR_OBJ

304:
305:
306: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
307: (
308: EGO_COL_NAME_VALUE_PAIR_OBJ
309: (
310: 'UDA_TEMPLATE_ID',p_template_id || ''
311: )
312: );

Line 5053: EGO_COL_NAME_VALUE_PAIR_OBJ(

5049: END IF;
5050: END LOOP;
5051:
5052: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5053: EGO_COL_NAME_VALUE_PAIR_OBJ(
5054: 'PO_HEADER_ID', p_po_header_id
5055: ),
5056: EGO_COL_NAME_VALUE_PAIR_OBJ(
5057: 'DRAFT_ID', p_po_draft_id

Line 5056: EGO_COL_NAME_VALUE_PAIR_OBJ(

5052: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5053: EGO_COL_NAME_VALUE_PAIR_OBJ(
5054: 'PO_HEADER_ID', p_po_header_id
5055: ),
5056: EGO_COL_NAME_VALUE_PAIR_OBJ(
5057: 'DRAFT_ID', p_po_draft_id
5058: )
5059: );
5060:

Line 5116: EGO_COL_NAME_VALUE_PAIR_OBJ

5112: END IF;
5113:
5114: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
5115: (
5116: EGO_COL_NAME_VALUE_PAIR_OBJ
5117: (
5118: 'UDA_TEMPLATE_ID'
5119: ,p_uda_template_id || ''
5120: )

Line 5250: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

5246: FROM FND_DESCR_FLEX_COLUMN_USAGES
5247: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
5248: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;
5249:
5250: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
5251: l_delimiter VARCHAR2(2);
5252:
5253: BEGIN
5254:

Line 5314: EGO_COL_NAME_VALUE_PAIR_OBJ(

5310: END;
5311: -- bug 13054072 ends
5312:
5313: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5314: EGO_COL_NAME_VALUE_PAIR_OBJ(
5315: 'PO_HEADER_ID', p_po_header_id
5316: ),
5317: EGO_COL_NAME_VALUE_PAIR_OBJ(
5318: 'DRAFT_ID', Nvl(p_draft_id,-1)

Line 5317: EGO_COL_NAME_VALUE_PAIR_OBJ(

5313: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
5314: EGO_COL_NAME_VALUE_PAIR_OBJ(
5315: 'PO_HEADER_ID', p_po_header_id
5316: ),
5317: EGO_COL_NAME_VALUE_PAIR_OBJ(
5318: 'DRAFT_ID', Nvl(p_draft_id,-1)
5319: )
5320: );
5321: