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.OKC_REP_UDA_FUNCTIONS dependencies on STANDARD

Line 70: ,x_size_standard IN OUT NOCOPY VARCHAR2

66: ,x_issuing_off_symbol IN OUT NOCOPY VARCHAR2
67: ,x_total_amount IN OUT NOCOPY NUMBER
68: ,x_currency IN OUT NOCOPY VARCHAR2
69: ,x_naics_code IN OUT NOCOPY VARCHAR2
70: ,x_size_standard IN OUT NOCOPY VARCHAR2
71: ,x_fsc_svc_code IN OUT NOCOPY VARCHAR2
72: ,x_item_long_desc IN OUT NOCOPY VARCHAR2
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_errorcode OUT NOCOPY VARCHAR2

Line 98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);

94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;
102:

Line 120: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN

116: FROM (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_source_doc_id
117: ORDER BY clm_amount DESC, item_description ASC)
118: WHERE rownum = 1;
119:
120: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
121: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
122: SELECT po_line_id INTO l_po_line_id
123: FROM (SELECT po_line_id FROM po_lines_draft_all WHERE draft_id = p_source_doc_id
124: ORDER BY getPoLineAmount(po_header_id, po_line_id, draft_id) DESC, item_description ASC)

Line 121: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)

117: ORDER BY clm_amount DESC, item_description ASC)
118: WHERE rownum = 1;
119:
120: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
121: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
122: SELECT po_line_id INTO l_po_line_id
123: FROM (SELECT po_line_id FROM po_lines_draft_all WHERE draft_id = p_source_doc_id
124: ORDER BY getPoLineAmount(po_header_id, po_line_id, draft_id) DESC, item_description ASC)
125: WHERE rownum = 1;

Line 153: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

149: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
150: INTO x_buyer_name
151: FROM pon_auction_headers_all
152: WHERE auction_header_id = p_source_doc_id;
153: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
154: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
155: INTO x_buyer_name
156: FROM po_headers_draft_all
157: WHERE draft_id = p_source_doc_id;

Line 191: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

187: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
188: INTO x_issuing_off_symbol
189: FROM pon_auction_headers_all
190: WHERE auction_header_id = p_source_doc_id;
191: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
192: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
193: INTO x_issuing_off_symbol
194: FROM po_headers_draft_all
195: WHERE draft_id = p_source_doc_id;

Line 228: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

224: IF p_source_doc_type = 'SOLICITATION' THEN
225: SELECT Sum(Nvl(clm_amount, 0)) INTO x_total_amount
226: FROM pon_auction_item_prices_all
227: WHERE auction_header_id = p_source_doc_id;
228: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
229: SELECT changed_amt INTO x_total_amount
230: FROM po_drafts
231: WHERE draft_id = p_source_doc_id;
232: END IF;

Line 264: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

260: IF p_source_doc_type = 'SOLICITATION' THEN
261: SELECT currency_code INTO x_currency
262: FROM pon_auction_headers_all
263: WHERE auction_header_id = p_source_doc_id;
264: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
265: SELECT currency_code INTO x_currency
266: FROM po_headers_draft_all
267: WHERE draft_id = p_source_doc_id;
268: END IF;

Line 310: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD

306: INTO x_naics_code
307: FROM po_headers_draft_all
308: WHERE draft_id = p_source_doc_id;
309:
310: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD
311: x_naics_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
312: pk1_value => l_po_line_id,
313: pk2_value => p_source_doc_id,
314: p_attr_grp_int_name => 'FED_CUST_DESG',

Line 336: -- SIZE STANDARD DEFAULTING

332: END;
333: -- END IF;
334:
335: /*
336: -- SIZE STANDARD DEFAULTING
337: */
338: -- IF x_size_standard IS NULL THEN
339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');

Line 338: -- IF x_size_standard IS NULL THEN

334:
335: /*
336: -- SIZE STANDARD DEFAULTING
337: */
338: -- IF x_size_standard IS NULL THEN
339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');
341: END IF;
342:

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');

336: -- SIZE STANDARD DEFAULTING
337: */
338: -- IF x_size_standard IS NULL THEN
339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');
341: END IF;
342:
343: BEGIN
344: IF p_source_doc_type = 'SOLICITATION' THEN

Line 345: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')

341: END IF;
342:
343: BEGIN
344: IF p_source_doc_type = 'SOLICITATION' THEN
345: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

Line 346: INTO x_size_standard

342:
343: BEGIN
344: IF p_source_doc_type = 'SOLICITATION' THEN
345: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')

Line 349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD

345: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
351: INTO x_size_standard
352: FROM po_headers_draft_all
353: WHERE draft_id = p_source_doc_id;

Line 350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')

346: INTO x_size_standard
347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
351: INTO x_size_standard
352: FROM po_headers_draft_all
353: WHERE draft_id = p_source_doc_id;
354: END IF;

Line 351: INTO x_size_standard

347: FROM pon_auction_headers_all
348: WHERE auction_header_id = p_source_doc_id;
349: ELSE --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD, PA_CONTRACT_MOD
350: SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
351: INTO x_size_standard
352: FROM po_headers_draft_all
353: WHERE draft_id = p_source_doc_id;
354: END IF;
355:

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);

353: WHERE draft_id = p_source_doc_id;
354: END IF;
355:
356: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 364: x_msg_data := 'Exception in defaulting Size Standard';

360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_errorcode := '-9';
363: x_msg_count := '1';
364: x_msg_data := 'Exception in defaulting Size Standard';
365: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
366:
367: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);

364: x_msg_data := 'Exception in defaulting Size Standard';
365: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
366:
367: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);
369: END IF;
370: END;
371: -- END IF;
372:

Line 400: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD

396: IF l_fsc_svc_codes IS NOT NULL AND l_fsc_svc_codes.COUNT > 0 THEN
397: x_fsc_svc_code := l_fsc_svc_codes(1);
398: END IF;
399:
400: ELSE -- for doc types PO_STANDARD_MOD, PA_BLANKET_MOD
401: x_fsc_svc_code := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
402: pk1_value => l_po_line_id,
403: pk2_value => p_source_doc_id,
404: p_attr_grp_int_name => 'FED_CUST_DESG',

Line 441: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN

437: pk2_value => l_auc_line_num,
438: p_attr_grp_int_name => 'ADD_ITEM_INFO',
439: p_attr_int_name => 'EXTND_DESC');
440:
441: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
442: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
443: x_item_long_desc := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
444: pk1_value => l_po_line_id,
445: pk2_value => p_source_doc_id,

Line 442: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)

438: p_attr_grp_int_name => 'ADD_ITEM_INFO',
439: p_attr_int_name => 'EXTND_DESC');
440:
441: ELSIF p_source_doc_type = 'PO_STANDARD_MOD' OR p_source_doc_type = 'PA_BLANKET_MOD' THEN
442: --for doc types PO_STANDARD_MOD, PA_BLANKET_MOD (PA_CONTRACT_MOD doesn't have lines)
443: x_item_long_desc := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',
444: pk1_value => l_po_line_id,
445: pk2_value => p_source_doc_id,
446: p_attr_grp_int_name => 'ADD_ITEM_INFO',

Line 479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);

Line 505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);