APPS.PO_DOC_NUMBERING_PKG dependencies on PO_UDA_USAGE_OBJECT

Line 19: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

15: d_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DOC_NUMBER_UDA';
16: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
17: d_progress NUMBER := 0;
18:
19: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
20: l_template_id NUMBER;
21: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
22: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
23:

Line 21: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;

17: d_progress NUMBER := 0;
18:
19: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
20: l_template_id NUMBER;
21: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
22: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
23:
24: l_return_status VARCHAR2(2);
25: l_errorcode NUMBER;

Line 67: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();

63: PO_LOG.proc_begin(d_module, 'p_source_org_owned', p_source_org_owned);
64: PO_LOG.proc_begin(d_module, 'p_caller', p_caller);
65: END IF;
66:
67: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
68: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
69:
70: IF p_caller = 'PO' AND l_source_org_owned <> 'NA' THEN
71: --In this case we need to get the the Source IDV number from the DB

Line 68: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();

64: PO_LOG.proc_begin(d_module, 'p_caller', p_caller);
65: END IF;
66:
67: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
68: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
69:
70: IF p_caller = 'PO' AND l_source_org_owned <> 'NA' THEN
71: --In this case we need to get the the Source IDV number from the DB
72: --and pass it as an external parameter

Line 114: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,'DOCUMENT_NUMBERING',l_context );

110: po_moac_utils_pvt.get_current_org_id*/
111: );
112: END IF;
113:
114: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,'DOCUMENT_NUMBERING',l_context );
115: l_po_uda_usage_object_array.EXTEND(1);
116: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
117:
118: l_external_attr_value_pairs := NULL;

Line 115: l_po_uda_usage_object_array.EXTEND(1);

111: );
112: END IF;
113:
114: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,'DOCUMENT_NUMBERING',l_context );
115: l_po_uda_usage_object_array.EXTEND(1);
116: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
117:
118: l_external_attr_value_pairs := NULL;
119:

Line 116: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;

112: END IF;
113:
114: l_po_uda_usage_object := po_uda_usage_object.new_instance(p_template_id,'DOCUMENT_NUMBERING',l_context );
115: l_po_uda_usage_object_array.EXTEND(1);
116: l_po_uda_usage_object_array(l_po_uda_usage_object_array.COUNT) := l_po_uda_usage_object;
117:
118: l_external_attr_value_pairs := NULL;
119:
120: G_PO_VALIDATION_EVENT_TYPE := 'DEFAULT_DOC' ; --The XV has to skip the validation for 'XXXX' serial number first time.

Line 137: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

133: ,p_pk2_value => p_draft_id
134: ,p_template_id => p_template_id
135: ,p_address_lookup_type => null
136: ,x_external_attr_value_pairs => l_external_attr_value_pairs
137: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
138: ,x_return_status => l_return_status
139: ,x_errorcode => l_errorcode
140: ,x_msg_count => l_msg_count
141: ,x_msg_data => l_msg_data

Line 152: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

148: p_pk1_value => p_doc_header_id
149: ,p_template_id => p_template_id
150: ,p_address_lookup_type => null
151: ,x_external_attr_value_pairs => l_external_attr_value_pairs
152: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
153: ,x_return_status => l_return_status
154: ,x_errorcode => l_errorcode
155: ,x_msg_count => l_msg_count
156: ,x_msg_data => l_msg_data

Line 173: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array

169: p_pk1_value => p_doc_header_id
170: ,p_template_id => p_template_id
171: ,p_address_lookup_type => null
172: ,x_external_attr_value_pairs => l_external_attr_value_pairs
173: ,x_po_uda_usage_object_array => l_po_uda_usage_object_array
174: ,x_return_status => l_return_status
175: ,x_errorcode => l_errorcode
176: ,x_msg_count => l_msg_count
177: ,x_msg_data => l_msg_data

Line 183: l_attrb_grp_id := l_po_uda_usage_object.Attr_group_Id(1);

179: END IF;
180:
181: /* Bug 13241358/12881115 get the attribute group id from
182: usage object, using the attr_group_id get attr group name*/
183: l_attrb_grp_id := l_po_uda_usage_object.Attr_group_Id(1);
184:
185: IF PO_LOG.d_stmt THEN
186: PO_LOG.stmt(d_module, d_progress, 'l_attrb_grp_id : ', l_attrb_grp_id);
187: END IF;