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.PO_COPYDOC_S1 dependencies on PO_HEADERS

Line 48: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,

44:
45: -- Private function prototypes
46:
47: PROCEDURE fetch_header(
48: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
49: x_from_po_header_id IN po_headers.po_header_id%TYPE,
50: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
51: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
52: x_return_code OUT NOCOPY NUMBER

Line 49: x_from_po_header_id IN po_headers.po_header_id%TYPE,

45: -- Private function prototypes
46:
47: PROCEDURE fetch_header(
48: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
49: x_from_po_header_id IN po_headers.po_header_id%TYPE,
50: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
51: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
52: x_return_code OUT NOCOPY NUMBER
53: );

Line 55: x_po_header_record IN PO_HEADERS%ROWTYPE,

51: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
52: x_return_code OUT NOCOPY NUMBER
53: );
54: PROCEDURE insert_header(
55: x_po_header_record IN PO_HEADERS%ROWTYPE,
56: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
57: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
58: x_return_code OUT NOCOPY NUMBER,
59: x_copy_terms IN VARCHAR2 --

Line 95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

91: );
92:
93: PROCEDURE process_header(
94: x_action_code IN VARCHAR2,
95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,

Line 96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA

92:
93: PROCEDURE process_header(
94: x_action_code IN VARCHAR2,
95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,
100: x_agent_id IN po_headers.agent_id%TYPE,

Line 97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,

93: PROCEDURE process_header(
94: x_action_code IN VARCHAR2,
95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,
100: x_agent_id IN po_headers.agent_id%TYPE,
101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 98: x_from_po_header_id IN po_headers.po_header_id%TYPE,

94: x_action_code IN VARCHAR2,
95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,
100: x_agent_id IN po_headers.agent_id%TYPE,
101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
102: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 99: x_to_segment1 IN po_headers.segment1%TYPE,

95: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,
100: x_agent_id IN po_headers.agent_id%TYPE,
101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
102: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
103: x_copy_attachments IN BOOLEAN,

Line 100: x_agent_id IN po_headers.agent_id%TYPE,

96: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
97: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
98: x_from_po_header_id IN po_headers.po_header_id%TYPE,
99: x_to_segment1 IN po_headers.segment1%TYPE,
100: x_agent_id IN po_headers.agent_id%TYPE,
101: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
102: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
103: x_copy_attachments IN BOOLEAN,
104: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 112: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

108: );
109:
110: PROCEDURE process_line(
111: x_action_code IN VARCHAR2,
112: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
113: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
114: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
115: x_wip_install_status IN VARCHAR2,
116: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 157: p_po_header_rec IN PO_HEADERS%ROWTYPE,

153: p_orig_po_distribution_id IN NUMBER,
154: p_generate_new_accounts IN BOOLEAN,
155: p_copy_attachments IN BOOLEAN,
156: p_online_report_id IN NUMBER,
157: p_po_header_rec IN PO_HEADERS%ROWTYPE,
158: p_po_line_rec IN PO_LINES%ROWTYPE,
159: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
160: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
161: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

Line 174: g_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%TYPE;

170: -- Global variable declarations
171:
172: g_debug_flag BOOLEAN := TRUE;
173: --
174: g_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%TYPE;
175:
176: -- End of Global variable declarations
177:
178:

Line 381: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,

377: ** Get all the header info for the document with x_from_po_header_id
378: ** and store into x_po_header_record for future processing
379: *************************************************************/
380: PROCEDURE fetch_header(
381: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
382: x_from_po_header_id IN po_headers.po_header_id%TYPE,
383: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
384: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
385: x_return_code OUT NOCOPY NUMBER

Line 382: x_from_po_header_id IN po_headers.po_header_id%TYPE,

378: ** and store into x_po_header_record for future processing
379: *************************************************************/
380: PROCEDURE fetch_header(
381: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
382: x_from_po_header_id IN po_headers.po_header_id%TYPE,
383: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
384: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
385: x_return_code OUT NOCOPY NUMBER
386: ) IS

Line 396: FROM PO_HEADERS

392: x_progress := '001';
393:
394: SELECT *
395: INTO x_po_header_record
396: FROM PO_HEADERS
397: WHERE po_header_id = x_from_po_header_id;
398:
399: x_return_code := 0;
400:

Line 415: x_po_header_record IN PO_HEADERS%ROWTYPE,

411: /****************************************************************
412: ** create new PO record from info. stored in x_po_header_record
413: ****************************************************************/
414: PROCEDURE insert_header(
415: x_po_header_record IN PO_HEADERS%ROWTYPE,
416: x_online_report_id IN po_online_report_text.online_report_id%TYPE,
417: x_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
418: x_return_code OUT NOCOPY NUMBER,
419: x_copy_terms IN VARCHAR2 --

Line 452: INSERT INTO PO_HEADERS (

448: -- Bug #2015328, added decode statements to null out start_date and
449: -- end_date when a standard purchase order is copied from other type
450: -- of docs. This is because the std. purchase order should not have
451: -- the start and end date defined in terms and conditions.
452: INSERT INTO PO_HEADERS (
453: acceptance_due_date,
454: acceptance_required_flag,
455: agent_id,
456: amount_limit,

Line 1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;

1173:
1174: l_progress VARCHAR2(4);
1175:
1176: --bug #2717053: changed var names/types to conform to standards
1177: l_vendor_site_id po_headers.vendor_site_id%TYPE := null;
1178: l_to_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;

Line 1183: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;

1179: l_to_ship_to_organization_id po_line_locations.ship_to_organization_id%TYPE;
1180: l_item_id po_lines.item_id%TYPE := null;
1181: l_count number:= 0;
1182: l_quantity po_line_locations.quantity%TYPE;
1183: l_quote_type_code po_headers.quote_type_lookup_code%TYPE := null;
1184:
1185: x_sob_id number:= null;
1186:
1187: -- CONSIGNED FPI START

Line 1190: po_headers.vendor_id%TYPE := null;

1186:
1187: -- CONSIGNED FPI START
1188: -- Bug Fix for #2697755: COPY PO WITH CONSIGNED SHIPMENT LINE FAILS
1189: l_vendor_id
1190: po_headers.vendor_id%TYPE := null;
1191: l_consigned_flag
1192: po_line_locations.consigned_flag%TYPE := null;
1193: l_consigned_from_supplier_flag
1194: po_asl_attributes.consigned_from_supplier_flag%TYPE := null;

Line 1286: FROM po_headers ph

1282:
1283: Begin
1284: SELECT ph.quote_type_lookup_code
1285: INTO l_quote_type_code
1286: FROM po_headers ph
1287: WHERE ph.po_header_id = x_po_shipment_record.po_header_id;
1288: Exception
1289: When others then
1290: l_quote_type_code := NULL;

Line 1369: po_headers where

1365: l_progress := '070';
1366:
1367: begin
1368: select vendor_site_id into l_vendor_site_id from
1369: po_headers where
1370: po_header_id=x_po_shipment_record.po_header_id;
1371:
1372: select ship_to_location_id into l_to_ship_to_location_id
1373: from po_vendor_sites where

Line 1436: from po_headers

1432: l_progress := '110';
1433:
1434: select vendor_id, vendor_site_id
1435: into l_vendor_id, l_vendor_site_id
1436: from po_headers
1437: where po_header_id = x_po_shipment_record.po_header_id;
1438:
1439: l_progress := '120';
1440:

Line 2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

2229: ** Copy attachment if necessary
2230: ***************************************************************/
2231: PROCEDURE process_header(
2232: x_action_code IN VARCHAR2,
2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,

Line 2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA

2230: ***************************************************************/
2231: PROCEDURE process_header(
2232: x_action_code IN VARCHAR2,
2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,
2238: x_agent_id IN po_headers.agent_id%TYPE,

Line 2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,

2231: PROCEDURE process_header(
2232: x_action_code IN VARCHAR2,
2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,
2238: x_agent_id IN po_headers.agent_id%TYPE,
2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,

2232: x_action_code IN VARCHAR2,
2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,
2238: x_agent_id IN po_headers.agent_id%TYPE,
2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2240: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,

Line 2237: x_to_segment1 IN po_headers.segment1%TYPE,

2233: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,
2238: x_agent_id IN po_headers.agent_id%TYPE,
2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2240: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2241: x_copy_attachments IN BOOLEAN,

Line 2238: x_agent_id IN po_headers.agent_id%TYPE,

2234: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2235: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2236: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2237: x_to_segment1 IN po_headers.segment1%TYPE,
2238: x_agent_id IN po_headers.agent_id%TYPE,
2239: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
2240: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
2241: x_copy_attachments IN BOOLEAN,
2242: x_online_report_id IN po_online_report_text.online_report_id%TYPE,

Line 2252: l_po_from_document_type po_headers.type_lookup_code%TYPE;

2248: l_progress VARCHAR2(4);
2249: x_internal_return_code NUMBER := NULL;
2250:
2251: /* FPJ CONTERMS START */
2252: l_po_from_document_type po_headers.type_lookup_code%TYPE;
2253: l_contracts_from_document_type VARCHAR2(150); --Change this in 11iX
2254: l_contracts_to_document_type VARCHAR2(150); --Change this in 11iX
2255:
2256: l_return_status VARCHAR2(1);

Line 2262: l_internal_party_id po_headers_all.org_id%TYPE;

2258: l_msg_data VARCHAR2(2000);
2259:
2260: l_conterms_exist_flag VARCHAR2(1);
2261: l_temp_copy_terms VARCHAR2(1);
2262: l_internal_party_id po_headers_all.org_id%TYPE;
2263: l_internal_contact_id po_headers_all.agent_id%TYPE;
2264: l_external_party_id po_headers_all.vendor_id%TYPE;
2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;

Line 2263: l_internal_contact_id po_headers_all.agent_id%TYPE;

2259:
2260: l_conterms_exist_flag VARCHAR2(1);
2261: l_temp_copy_terms VARCHAR2(1);
2262: l_internal_party_id po_headers_all.org_id%TYPE;
2263: l_internal_contact_id po_headers_all.agent_id%TYPE;
2264: l_external_party_id po_headers_all.vendor_id%TYPE;
2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2267: l_copy_contracts_attachments VARCHAR2(1) := 'N';

Line 2264: l_external_party_id po_headers_all.vendor_id%TYPE;

2260: l_conterms_exist_flag VARCHAR2(1);
2261: l_temp_copy_terms VARCHAR2(1);
2262: l_internal_party_id po_headers_all.org_id%TYPE;
2263: l_internal_contact_id po_headers_all.agent_id%TYPE;
2264: l_external_party_id po_headers_all.vendor_id%TYPE;
2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2267: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2268: /* FPJ CONTERMS END */

Line 2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;

2261: l_temp_copy_terms VARCHAR2(1);
2262: l_internal_party_id po_headers_all.org_id%TYPE;
2263: l_internal_contact_id po_headers_all.agent_id%TYPE;
2264: l_external_party_id po_headers_all.vendor_id%TYPE;
2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2267: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2268: /* FPJ CONTERMS END */
2269:

Line 2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;

2262: l_internal_party_id po_headers_all.org_id%TYPE;
2263: l_internal_contact_id po_headers_all.agent_id%TYPE;
2264: l_external_party_id po_headers_all.vendor_id%TYPE;
2265: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2266: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2267: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2268: /* FPJ CONTERMS END */
2269:
2270: BEGIN

Line 2352: FROM po_headers

2348: ,l_internal_contact_id
2349: ,l_external_party_id
2350: ,l_external_party_site_id
2351: ,l_external_contact_id
2352: FROM po_headers
2353: WHERE po_header_id = x_from_po_header_id;
2354:
2355: -- contract terms exist and user has chosen to copy
2356: IF (UPPER(l_conterms_exist_flag) = 'Y') THEN

Line 2431: UPDATE po_headers_all

2427: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2428: l_progress := '070';
2429:
2430: -- terms copying failed , set conterms exist flag on the new doc to N
2431: UPDATE po_headers_all
2432: SET conterms_exist_flag = 'N'
2433: WHERE po_header_id = x_po_header_record.po_header_id;
2434: END IF; -- return status is error
2435:

Line 2445: fnd_attached_documents2_pkg.copy_attachments('PO_HEADERS',

2441: l_progress := '080';
2442:
2443: IF (x_copy_attachments) THEN
2444: l_progress := '090';
2445: fnd_attached_documents2_pkg.copy_attachments('PO_HEADERS',
2446: x_from_po_header_id,
2447: '',
2448: '',
2449: '',

Line 2451: 'PO_HEADERS',

2447: '',
2448: '',
2449: '',
2450: '',
2451: 'PO_HEADERS',
2452: x_po_header_record.po_header_id,
2453: '',
2454: '',
2455: '',

Line 2562: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

2558: --
2559:
2560: PROCEDURE process_line(
2561: x_action_code IN VARCHAR2,
2562: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2563: x_po_line_record IN OUT NOCOPY po_lines%ROWTYPE,
2564: x_orig_po_line_id IN po_lines.po_line_id%TYPE,
2565: x_wip_install_status IN VARCHAR2,
2566: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 2981: p_po_header_rec IN PO_HEADERS%ROWTYPE,

2977: p_orig_po_distribution_id IN NUMBER,
2978: p_generate_new_accounts IN BOOLEAN,
2979: p_copy_attachments IN BOOLEAN,
2980: p_online_report_id IN NUMBER,
2981: p_po_header_rec IN PO_HEADERS%ROWTYPE,
2982: p_po_line_rec IN PO_LINES%ROWTYPE,
2983: p_po_shipment_rec IN PO_LINE_LOCATIONS%ROWTYPE,
2984: p_sob_id IN FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE,
2985: x_po_distribution_rec IN OUT NOCOPY PO_DISTRIBUTIONS%ROWTYPE,

Line 3171: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,

3167: -- we would mantain the existing behavior
3168: --
3169: PROCEDURE copy_document(
3170: x_action_code IN VARCHAR2,
3171: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
3172: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
3173: x_copy_attachments IN BOOLEAN,
3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,

Line 3172: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA

3168: --
3169: PROCEDURE copy_document(
3170: x_action_code IN VARCHAR2,
3171: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
3172: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
3173: x_copy_attachments IN BOOLEAN,
3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,

Line 3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,

3171: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
3172: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
3173: x_copy_attachments IN BOOLEAN,
3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3177: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3179: x_agent_id IN po_headers.agent_id%TYPE,

Line 3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,

3172: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
3173: x_copy_attachments IN BOOLEAN,
3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3177: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3179: x_agent_id IN po_headers.agent_id%TYPE,
3180: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,

Line 3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,

3174: x_copy_price IN BOOLEAN,
3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3177: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3179: x_agent_id IN po_headers.agent_id%TYPE,
3180: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
3181: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
3182: x_wip_install_status IN VARCHAR2,

Line 3179: x_agent_id IN po_headers.agent_id%TYPE,

3175: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3176: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,
3177: x_online_report_id OUT NOCOPY po_online_report_text.online_report_id%TYPE,
3178: x_to_segment1 IN OUT NOCOPY po_headers.segment1%TYPE,
3179: x_agent_id IN po_headers.agent_id%TYPE,
3180: x_sob_id IN financials_system_parameters.set_of_books_id%TYPE,
3181: x_inv_org_id IN financials_system_parameters.inventory_organization_id%TYPE,
3182: x_wip_install_status IN VARCHAR2,
3183: x_return_code OUT NOCOPY NUMBER,

Line 3191: x_po_header_record PO_HEADERS%ROWTYPE;

3187: ) IS
3188:
3189: COPYDOC_FATAL EXCEPTION;
3190:
3191: x_po_header_record PO_HEADERS%ROWTYPE;
3192: x_po_line_record po_lines%ROWTYPE;
3193: x_po_shipment_record po_line_locations%ROWTYPE;
3194: x_po_distribution_record po_distributions%ROWTYPE;
3195:

Line 3211: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;

3207: x_sequence po_online_report_text.sequence%TYPE := 1;
3208: /* this is used only for BID quotation to calculate quantity at the line
3209: level from shipments. */
3210: x_line_quantity NUMBER;
3211: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;
3212:
3213: --< Shared Proc FPJ Start >
3214: l_orig_txn_flow_header_id
3215: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

Line 3385: FROM po_headers

3381: x_progress := '048';
3382:
3383: SELECT quotation_class_code
3384: INTO x_orig_quotation_class_code
3385: FROM po_headers
3386: WHERE po_header_id = x_from_po_header_id;
3387:
3388: OPEN po_line_cursor(x_from_po_header_id);
3389:

Line 3608: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE

3604: * Returns: TRUE if any of the shipments in the given PO are drop ship,
3605: * FALSE otherwise.
3606: **/
3607: FUNCTION po_is_dropship (
3608: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
3609: ) RETURN BOOLEAN IS
3610:
3611: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
3612: SELECT line_location_id

Line 3611: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS

3607: FUNCTION po_is_dropship (
3608: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
3609: ) RETURN BOOLEAN IS
3610:
3611: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
3612: SELECT line_location_id
3613: FROM PO_LINE_LOCATIONS
3614: WHERE po_header_id = p_po_header_id
3615: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');

Line 3668: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

3664: --End of Comments
3665: ----------------------------------------------------------------------------
3666:
3667: FUNCTION po_has_config_id(
3668: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
3669: ) RETURN BOOLEAN IS
3670:
3671: l_has_config_id NUMBER;
3672:

Line 3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;

3797: ,x_text_line OUT NOCOPY VARCHAR2
3798: ,x_return_status OUT NOCOPY VARCHAR2
3799: ,x_exception_msg OUT NOCOPY VARCHAR2)
3800: IS
3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;

Line 3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;

3798: ,x_return_status OUT NOCOPY VARCHAR2
3799: ,x_exception_msg OUT NOCOPY VARCHAR2)
3800: IS
3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
3806: l_return_code NUMBER;

Line 3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;

3799: ,x_exception_msg OUT NOCOPY VARCHAR2)
3800: IS
3801: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
3802: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
3803: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
3804: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
3805: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
3806: l_return_code NUMBER;
3807: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

Line 3837: FROM po_headers_all POH, financials_system_params_all FSP

3833: FSP.SET_OF_BOOKS_ID
3834: INTO l_doc_org_id, l_type_lookup_code,
3835: l_global_agreement_flag,
3836: l_inv_org_id, l_sob_id
3837: FROM po_headers_all POH, financials_system_params_all FSP
3838: WHERE po_header_id = p_po_header_id
3839: AND poh.org_id = fsp.org_id;
3840:
3841: IF PO_LOG.d_stmt THEN