APPS.IGC_CC_PO_INTERFACE_PKG dependencies on STANDARD

Line 75: /* Standard default values PO Columns */

71: l_po_headers_rec.created_by := p_cc_headers_rec.created_by;
72: l_po_headers_rec.last_update_date := p_cc_headers_rec.last_update_date;
73: l_po_headers_rec.last_updated_by := p_cc_headers_rec.last_updated_by;
74:
75: /* Standard default values PO Columns */
76:
77: IF (p_mode = 'I') THEN
78: l_po_headers_rec.type_lookup_code := 'STANDARD';
79: l_po_headers_rec.summary_flag := 'N';

Line 78: l_po_headers_rec.type_lookup_code := 'STANDARD';

74:
75: /* Standard default values PO Columns */
76:
77: IF (p_mode = 'I') THEN
78: l_po_headers_rec.type_lookup_code := 'STANDARD';
79: l_po_headers_rec.summary_flag := 'N';
80: l_po_headers_rec.enabled_flag := 'Y';
81: l_po_headers_rec.fob_lookup_code := 'Destination';
82: l_po_headers_rec.freight_terms_lookup_code := 'TBD';

Line 495: l_po_line_locs_rec.shipment_type := 'STANDARD';

491: l_po_line_locs_rec.days_late_receipt_allowed := 99;
492: l_po_line_locs_rec.receipt_days_exception_code := 'WARNING';
493: l_po_line_locs_rec.invoice_close_tolerance := 0;
494: l_po_line_locs_rec.receive_close_tolerance := 0;
495: l_po_line_locs_rec.shipment_type := 'STANDARD';
496: l_po_line_locs_rec.closed_code := 'OPEN';
497: l_po_line_locs_rec.receiving_routing_id := 2;
498: l_po_line_locs_rec.accrue_on_receipt_flag := 'N';
499: l_po_line_locs_rec.tax_user_override_flag := 'N';

Line 622: l_po_dist_rec.distribution_type := 'STANDARD';

618: l_po_dist_rec.line_location_id := p_po_line_locs_rec.line_location_id;
619: l_po_dist_rec.distribution_num := p_cc_pmt_fcst_rec.cc_det_pf_line_num;
620: -- Added for PRC.FP.J, 3173178
621: -- PO Standalone patch 3205071 is a pre-req for this change
622: l_po_dist_rec.distribution_type := 'STANDARD';
623:
624: IF (p_encumbrance_on = FND_API.G_TRUE) THEN
625: l_po_dist_rec.encumbered_flag := p_po_line_locs_rec.encumbered_flag;
626: l_po_dist_rec.gl_encumbered_date := p_cc_pmt_fcst_rec.cc_det_pf_encmbrnc_date;

Line 937: type_lookup_code = 'STANDARD' AND

933:
934: SELECT * INTO l_po_headers_rec
935: FROM PO_HEADERS_ALL
936: WHERE segment1 = l_cc_headers_rec.cc_num AND
937: type_lookup_code = 'STANDARD' AND
938: org_id = l_cc_headers_rec.org_id;
939: EXCEPTION
940: WHEN no_data_found
941: THEN

Line 1371: type_lookup_code = 'STANDARD' AND

1367:
1368: SELECT * INTO l_po_headers_rec
1369: FROM PO_HEADERS_ALL
1370: WHERE segment1 = l_cc_headers_rec.cc_num AND
1371: type_lookup_code = 'STANDARD' AND
1372: org_id = l_cc_headers_rec.org_id;
1373:
1374: EXCEPTION
1375: WHEN no_data_found

Line 1958: type_lookup_code = 'STANDARD' AND

1954: -- memory used. Performance tuning project
1955: SELECT po_header_id
1956: FROM po_headers_all
1957: WHERE segment1 = p_cc_num AND
1958: type_lookup_code = 'STANDARD' AND
1959: org_id = p_org_id
1960: FOR UPDATE NOWAIT;
1961:
1962: Recinfo C%ROWTYPE;