DBA Data[Home] [Help]

APPS.PO_EDA_IDX_FILE_GEN dependencies on PO_UDA_PUB

Line 107: ContractNumber := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

103:
104: fnd_file.put_line(FND_FILE.LOG,'l_isorderoffidv '||l_isorderoffidv);
105:
106: IF l_isorderoffidv = 'N' THEN
107: ContractNumber := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
108: pk1_value => p_doc_id,
109: pk2_value => -1,
110: p_attr_grp_int_name => 'DOD_AWD',
111: p_attr_int_name => 'DOC_NUMBER') ;

Line 117: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

113: ContractNumber := REPLACE(ContractNumber,'-','');
114:
115: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);
116:
117: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
118: pk1_value => p_doc_id,
119: pk2_value => p_draft_id,
120: p_attr_grp_int_name => 'DOD_AWD_MOD',
121: p_attr_int_name => 'MODIF_TYPE');

Line 126: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

122:
123: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);
124:
125: IF l_modiftype = 'ACO' THEN
126: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
127: pk1_value => p_doc_id,
128: pk2_value => p_draft_id,
129: p_attr_grp_int_name => 'DOD_AWD_MOD',
130: p_attr_int_name => 'SERIAL_NUMBER') ;

Line 135: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

131:
132: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);
133:
134: ELSIF l_modiftype = 'PCO' THEN
135: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
136: pk1_value => p_doc_id,
137: pk2_value => p_draft_id,
138: p_attr_grp_int_name => 'DOD_AWD_MOD',
139: p_attr_int_name => 'SERIAL_NUMBER') ;

Line 146: ContractNumber := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

142:
143: END IF;
144:
145: ELSE
146: ContractNumber := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
147: pk1_value => p_doc_id,
148: pk2_value => -1,
149: p_attr_grp_int_name => 'DOD_ORD_OW',
150: p_attr_int_name => 'SOURCE_DOC_NUM') ;

Line 156: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

152: ContractNumber := REPLACE(ContractNumber,'-','');
153:
154: fnd_file.put_line(FND_FILE.LOG,'ContractNumber '||ContractNumber);
155:
156: l_modiftype := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
157: pk1_value => p_doc_id,
158: pk2_value => p_draft_id,
159: p_attr_grp_int_name => 'DOD_ORD_MOD',
160: p_attr_int_name => 'MODIF_TYPE');

Line 166: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

162: fnd_file.put_line(FND_FILE.LOG,'l_modiftype '||l_modiftype);
163:
164:
165: IF l_modiftype = 'ACO' THEN
166: ACOMod := 'A' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
167: pk1_value => p_doc_id,
168: pk2_value => p_draft_id,
169: p_attr_grp_int_name => 'DOD_ORD_MOD',
170: p_attr_int_name => 'SERIAL_NUMBER') ;

Line 175: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

171:
172: fnd_file.put_line(FND_FILE.LOG,'ACOMod '||ACOMod);
173:
174: ELSIF l_modiftype = 'PCO' THEN
175: PCOMod := 'P' || PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
176: pk1_value => p_doc_id,
177: pk2_value => p_draft_id,
178: p_attr_grp_int_name => 'DOD_ORD_MOD',
179: p_attr_int_name => 'SERIAL_NUMBER') ;

Line 188: DeliveryOrder := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

184:
185: END IF;
186:
187:
188: DeliveryOrder := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
189: pk1_value => p_doc_id,
190: pk2_value => p_draft_id,
191: p_attr_grp_int_name => 'DOD_ORD_OW',
192: p_attr_int_name => 'SERIAL_NUMBER') ;

Line 204: IssuingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

200: fnd_file.put_line(FND_FILE.LOG,'IssueDate '||IssueDateInChar);
201:
202: IF P_IS_MOD = 'Y' THEN
203:
204: IssuingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
205: pk1_value => p_doc_id,
206: pk2_value => p_draft_id,
207: p_attr_grp_int_name => 'addresses',
208: p_attr_int_name => 'addresscode',

Line 213: IssuingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

209: p_address_type => 'MOD_ISSUING_OFFICE') ;
210:
211: ELSE
212:
213: IssuingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
214: pk1_value => p_doc_id,
215: pk2_value => p_draft_id,
216: p_attr_grp_int_name => 'addresses',
217: p_attr_int_name => 'addresscode',

Line 225: AdminDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

221: fnd_file.put_line(FND_FILE.LOG,'IssuingDoDAAC '||IssuingDoDAAC);
222:
223: IF P_IS_MOD = 'Y' THEN
224:
225: AdminDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
226: pk1_value => p_doc_id,
227: pk2_value => p_draft_id,
228: p_attr_grp_int_name => 'addresses',
229: p_attr_int_name => 'addresscode',

Line 235: AdminDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

231:
232:
233: ELSE
234:
235: AdminDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
236: pk1_value => p_doc_id,
237: pk2_value => p_draft_id,
238: p_attr_grp_int_name => 'addresses',
239: p_attr_int_name => 'addresscode',

Line 245: PayingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',

241: END IF;
242: fnd_file.put_line(FND_FILE.LOG,'AdminDoDAAC '||AdminDoDAAC);
243:
244:
245: PayingDoDAAC := PO_UDA_PUB.GET_ADDRESS_ATTR_VALUE(p_entity_code => 'PO_HEADER_EXT_ATTRS',
246: pk1_value => p_doc_id,
247: pk2_value => p_draft_id,
248: p_attr_grp_int_name => 'addresses',
249: p_attr_int_name => 'addresscode',

Line 256: CAGECode := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

252:
253: fnd_file.put_line(FND_FILE.LOG,'PayingDoDAAC '||PayingDoDAAC);
254:
255:
256: CAGECode := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
257: pk1_value => p_doc_id,
258: pk2_value => p_draft_id,
259: p_attr_grp_int_name => 'SUPPLIER_DTLS',
260: p_attr_int_name => 'CAGE_CODE') ;

Line 263: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

259: p_attr_grp_int_name => 'SUPPLIER_DTLS',
260: p_attr_int_name => 'CAGE_CODE') ;
261: fnd_file.put_line(FND_FILE.LOG,'CAGECode '||CAGECode);
262:
263: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
264: pk1_value => p_doc_id,
265: pk2_value => p_draft_id,
266: p_attr_grp_int_name => 'SUPPLIER_DTLS',
267: p_attr_int_name => 'DUNS_NUM') ;

Line 271: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',

267: p_attr_int_name => 'DUNS_NUM') ;
268: fnd_file.put_line(FND_FILE.LOG,'DUNS '||DUNS);
269:
270: IF DUNS IS NULL THEN
271: DUNS := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_HEADER_EXT_ATTRS',
272: pk1_value => p_doc_id,
273: pk2_value => p_draft_id,
274: p_attr_grp_int_name => 'SUPPLIER_DTLS',
275: p_attr_int_name => 'DUNS_4_NUM') ;