DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on STANDARD

Line 314: IF l_po_doc_type = 'STANDARD' THEN

310: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_po_doc_type ' || l_po_doc_type);
311: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_rev_number ' || l_rev_number);
312: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_doc_num ' || l_doc_num);
313:
314: IF l_po_doc_type = 'STANDARD' THEN
315: l_contr_type := 'PO_STANDARD';
316: ELSIF l_po_doc_type = 'BLANKET' THEN
317: l_contr_type := 'PA_BLANKET';
318: ELSE

Line 315: l_contr_type := 'PO_STANDARD';

311: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_rev_number ' || l_rev_number);
312: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_doc_num ' || l_doc_num);
313:
314: IF l_po_doc_type = 'STANDARD' THEN
315: l_contr_type := 'PO_STANDARD';
316: ELSIF l_po_doc_type = 'BLANKET' THEN
317: l_contr_type := 'PA_BLANKET';
318: ELSE
319: l_contr_type := 'PA_CONTRACT';

Line 1004: IF l_type_lookup_code = 'STANDARD' THEN

1000: END IF;
1001:
1002: l_progress := 45;
1003:
1004: IF l_type_lookup_code = 'STANDARD' THEN
1005: IF (l_result = c_result_type_FAILURE AND
1006: l_open_mod_fail_type = c_result_type_FAILURE) THEN
1007: x_result_type := c_result_type_FAILURE;
1008: RETURN;

Line 1972: AND pha.type_lookup_code = 'STANDARD'

1968: FROM po_multi_mod_docs pmmd,
1969: po_headers_all pha
1970: WHERE pmmd.multi_mod_request_id = p_req_id
1971: AND pmmd.document_id = pha.po_header_id
1972: AND pha.type_lookup_code = 'STANDARD'
1973: AND EXISTS ( SELECT 1
1974: FROM po_line_locations_all poll
1975: WHERE pha.po_header_id = poll.po_header_id
1976: AND Nvl(poll.closed_code,'OPEN') = 'OPEN'

Line 2012: AND pha.type_lookup_code = 'STANDARD'

2008: FROM po_multi_mod_docs pmmd,
2009: po_headers_all pha
2010: WHERE pmmd.multi_mod_request_id = p_req_id
2011: AND pmmd.document_id = pha.po_header_id
2012: AND pha.type_lookup_code = 'STANDARD'
2013: AND EXISTS (SELECT 1
2014: FROM po_line_locations_all poll
2015: WHERE pha.po_header_id = poll.po_header_id
2016: AND nvl(poll.closed_code,'OPEN') IN ('OPEN','CLOSED FOR RECEIVING',' CLOSED FOR INVOICE')

Line 2052: AND pha.type_lookup_code = 'STANDARD'

2048: FROM po_headers_all pha,
2049: po_multi_mod_docs pmmd
2050: WHERE pmmd.multi_mod_request_id = p_req_id
2051: AND pmmd.document_id = pha.po_header_id
2052: AND pha.type_lookup_code = 'STANDARD'
2053: AND NOT EXISTS (SELECT 1
2054: FROM ap_invoice_distributions_all aid,
2055: ap_invoices_all aia,
2056: po_distributions_all pod,

Line 2090: AND pha.type_lookup_code = 'STANDARD'

2086: FROM po_headers_all pha,
2087: po_multi_mod_docs pmmd
2088: WHERE pmmd.multi_mod_request_id = p_req_id
2089: AND pmmd.document_id = pha.po_header_id
2090: AND pha.type_lookup_code = 'STANDARD'
2091: AND EXISTS (SELECT 1
2092: FROM ap_invoice_distributions_all aid,
2093: ap_invoices_all aia,
2094: po_distributions_all pod,

Line 2637: IF l_po_doc_type = 'STANDARD' THEN

2633: l_progress := 30;
2634: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_po_doc_type ' || l_po_doc_type);
2635: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_doc_num ' || l_doc_num);
2636:
2637: IF l_po_doc_type = 'STANDARD' THEN
2638: l_contract_type := 'PO_STANDARD';
2639: ELSIF l_po_doc_type = 'BLANKET' THEN
2640: l_contract_type := 'PA_BLANKET';
2641: ELSE

Line 2638: l_contract_type := 'PO_STANDARD';

2634: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_po_doc_type ' || l_po_doc_type);
2635: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_doc_num ' || l_doc_num);
2636:
2637: IF l_po_doc_type = 'STANDARD' THEN
2638: l_contract_type := 'PO_STANDARD';
2639: ELSIF l_po_doc_type = 'BLANKET' THEN
2640: l_contract_type := 'PA_BLANKET';
2641: ELSE
2642: l_contract_type := 'PA_CONTRACT';

Line 2820: select clm_document_number,type_lookup_code, Decode(type_lookup_code, 'STANDARD', 'PO', 'PA')

2816: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
2817:
2818: l_progress := 15;
2819:
2820: select clm_document_number,type_lookup_code, Decode(type_lookup_code, 'STANDARD', 'PO', 'PA')
2821: into l_doc_num,l_doc_subtype,l_doc_type
2822: from po_headers_all
2823: where po_header_id = l_document_id;
2824:

Line 3316: IF l_po_doc_type = 'STANDARD' THEN

3312: INTO l_po_doc_type, l_rev_number, l_doc_num
3313: FROM PO_HEADERS_ALL
3314: WHERE po_header_id = l_document_id;
3315:
3316: IF l_po_doc_type = 'STANDARD' THEN
3317: l_contr_type := 'PO_STANDARD';
3318: ELSIF l_po_doc_type = 'BLANKET' THEN
3319: l_contr_type := 'PA_BLANKET';
3320: ELSE

Line 3317: l_contr_type := 'PO_STANDARD';

3313: FROM PO_HEADERS_ALL
3314: WHERE po_header_id = l_document_id;
3315:
3316: IF l_po_doc_type = 'STANDARD' THEN
3317: l_contr_type := 'PO_STANDARD';
3318: ELSIF l_po_doc_type = 'BLANKET' THEN
3319: l_contr_type := 'PA_BLANKET';
3320: ELSE
3321: l_contr_type := 'PA_CONTRACT';