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_ALL

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

114:
115: PROCEDURE process_header(
116: x_action_code IN VARCHAR2,
117: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
118: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
119: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
120: x_from_po_header_id IN po_headers.po_header_id%TYPE,
121: x_to_segment1 IN po_headers.segment1%TYPE,
122: x_agent_id IN po_headers.agent_id%TYPE,

Line 197: g_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%TYPE;

193: -- Global variable declarations
194:
195: g_debug_flag BOOLEAN := TRUE;
196: --
197: g_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%TYPE;
198:
199: -- End of Global variable declarations
200:
201:

Line 470: l_ame_transaction_type po_headers_all.ame_transaction_type%type; --PO AME porting

466: l_msg_data VARCHAR2(2000);
467: l_msg_count NUMBER;
468: l_ame_approval_id NUMBER;
469: l_clm_default_dist VARCHAR2(1);
470: l_ame_transaction_type po_headers_all.ame_transaction_type%type; --PO AME porting
471: BEGIN
472:
473: l_progress := '000';
474:

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

2400: ***************************************************************/
2401: PROCEDURE process_header(
2402: x_action_code IN VARCHAR2,
2403: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
2404: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
2405: x_po_header_record IN OUT NOCOPY PO_HEADERS%ROWTYPE,
2406: x_from_po_header_id IN po_headers.po_header_id%TYPE,
2407: x_to_segment1 IN po_headers.segment1%TYPE,
2408: x_agent_id IN po_headers.agent_id%TYPE,

Line 2432: l_internal_party_id po_headers_all.org_id%TYPE;

2428: l_msg_data VARCHAR2(2000);
2429:
2430: l_conterms_exist_flag VARCHAR2(1);
2431: l_temp_copy_terms VARCHAR2(1);
2432: l_internal_party_id po_headers_all.org_id%TYPE;
2433: l_internal_contact_id po_headers_all.agent_id%TYPE;
2434: l_external_party_id po_headers_all.vendor_id%TYPE;
2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;

Line 2433: l_internal_contact_id po_headers_all.agent_id%TYPE;

2429:
2430: l_conterms_exist_flag VARCHAR2(1);
2431: l_temp_copy_terms VARCHAR2(1);
2432: l_internal_party_id po_headers_all.org_id%TYPE;
2433: l_internal_contact_id po_headers_all.agent_id%TYPE;
2434: l_external_party_id po_headers_all.vendor_id%TYPE;
2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2437: l_copy_contracts_attachments VARCHAR2(1) := 'N';

Line 2434: l_external_party_id po_headers_all.vendor_id%TYPE;

2430: l_conterms_exist_flag VARCHAR2(1);
2431: l_temp_copy_terms VARCHAR2(1);
2432: l_internal_party_id po_headers_all.org_id%TYPE;
2433: l_internal_contact_id po_headers_all.agent_id%TYPE;
2434: l_external_party_id po_headers_all.vendor_id%TYPE;
2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2437: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2438: /* FPJ CONTERMS END */

Line 2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;

2431: l_temp_copy_terms VARCHAR2(1);
2432: l_internal_party_id po_headers_all.org_id%TYPE;
2433: l_internal_contact_id po_headers_all.agent_id%TYPE;
2434: l_external_party_id po_headers_all.vendor_id%TYPE;
2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2437: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2438: /* FPJ CONTERMS END */
2439:

Line 2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;

2432: l_internal_party_id po_headers_all.org_id%TYPE;
2433: l_internal_contact_id po_headers_all.agent_id%TYPE;
2434: l_external_party_id po_headers_all.vendor_id%TYPE;
2435: l_external_party_site_id po_headers_all.vendor_site_id%TYPE;
2436: l_external_contact_id po_headers_all.vendor_contact_id%TYPE;
2437: l_copy_contracts_attachments VARCHAR2(1) := 'N';
2438: /* FPJ CONTERMS END */
2439:
2440: BEGIN

Line 2601: UPDATE po_headers_all

2597: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2598: l_progress := '070';
2599:
2600: -- terms copying failed , set conterms exist flag on the new doc to N
2601: UPDATE po_headers_all
2602: SET conterms_exist_flag = 'N'
2603: WHERE po_header_id = x_po_header_record.po_header_id;
2604: END IF; -- return status is error
2605:

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

3501: --
3502: PROCEDURE copy_document(
3503: x_action_code IN VARCHAR2,
3504: x_to_doc_subtype IN po_headers.type_lookup_code%TYPE,
3505: x_to_global_flag IN PO_HEADERS_ALL.global_agreement_flag%TYPE, -- GA
3506: x_copy_attachments IN BOOLEAN,
3507: x_copy_price IN BOOLEAN,
3508: x_from_po_header_id IN po_headers.po_header_id%TYPE,
3509: x_to_po_header_id OUT NOCOPY po_headers.po_header_id%TYPE,

Line 3704: FROM po_headers_all

3700: --update the clm_document_number
3701: IF po_clm_clo_util.getCLMStatus = 'Y' THEN
3702: SELECT UDA_TEMPLATE_ID, clm_source_document_id
3703: INTO l_template_id, l_clm_src_doc_id
3704: FROM po_headers_all
3705: WHERE PO_HEADER_ID = x_from_po_header_id;
3706:
3707: l_match_val := po_doc_numbering_pkg.get_owned_by_issuing_org(l_clm_src_doc_id);
3708:

Line 3726: UPDATE po_headers_all

3722: x_document_num := po_core_sv1.default_po_unique_identifier
3723: ('PO_HEADERS');
3724: END IF;
3725:
3726: UPDATE po_headers_all
3727: SET clm_document_number = l_doc_number,
3728: segment1 = x_document_num
3729: WHERE po_header_id = x_po_header_record.po_header_id;
3730: END IF;

Line 3952: WHERE style_id = (SELECT style_id FROM po_headers_all WHERE po_header_id = x_from_po_header_id);

3948:
3949: SELECT Nvl(contract_financing_flag,'N')
3950: INTO l_is_complex_finance_po
3951: FROM po_doc_style_headers
3952: WHERE style_id = (SELECT style_id FROM po_headers_all WHERE po_header_id = x_from_po_header_id);
3953:
3954:
3955: IF( l_is_complex_finance_po LIKE 'Y' AND x_po_shipment_record.shipment_type LIKE 'STANDARD') THEN
3956:

Line 4240: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE

4236: * Returns: TRUE if any of the shipments in the given PO are drop ship,
4237: * FALSE otherwise.
4238: **/
4239: FUNCTION po_is_dropship (
4240: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
4241: ) RETURN BOOLEAN IS
4242:
4243: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
4244: SELECT line_location_id

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

4239: FUNCTION po_is_dropship (
4240: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE
4241: ) RETURN BOOLEAN IS
4242:
4243: CURSOR l_po_shipment_csr(p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE) IS
4244: SELECT line_location_id
4245: FROM PO_LINE_LOCATIONS
4246: WHERE po_header_id = p_po_header_id
4247: AND SHIPMENT_TYPE NOT IN ('SCHEDULED','BLANKET');

Line 4300: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

4296: --End of Comments
4297: ----------------------------------------------------------------------------
4298:
4299: FUNCTION po_has_config_id(
4300: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
4301: ) RETURN BOOLEAN IS
4302:
4303: l_has_config_id NUMBER;
4304:

Line 4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;

4429: ,x_text_line OUT NOCOPY VARCHAR2
4430: ,x_return_status OUT NOCOPY VARCHAR2
4431: ,x_exception_msg OUT NOCOPY VARCHAR2)
4432: IS
4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;

Line 4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;

4430: ,x_return_status OUT NOCOPY VARCHAR2
4431: ,x_exception_msg OUT NOCOPY VARCHAR2)
4432: IS
4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;

Line 4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;

4431: ,x_exception_msg OUT NOCOPY VARCHAR2)
4432: IS
4433: l_doc_org_id PO_HEADERS_ALL.ORG_ID%type;
4434: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
4435: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
4436: l_inv_org_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type;
4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;
4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;

Line 4469: FROM po_headers_all POH, financials_system_params_all FSP

4465: FSP.SET_OF_BOOKS_ID
4466: INTO l_doc_org_id, l_type_lookup_code,
4467: l_global_agreement_flag,
4468: l_inv_org_id, l_sob_id
4469: FROM po_headers_all POH, financials_system_params_all FSP
4470: WHERE po_header_id = p_po_header_id
4471: AND poh.org_id = fsp.org_id;
4472:
4473: IF PO_LOG.d_stmt THEN

Line 4674: UPDATE PO_HEADERS_ALL

4670: IF p_level = 'HEADER' THEN
4671:
4672: IF PO_CLM_CLO_UTIL.Isclminstalled THEN
4673:
4674: UPDATE PO_HEADERS_ALL
4675: SET uda_template_id = x_po_header_record.uda_template_id,
4676: uda_template_date = x_po_header_record.uda_template_date,
4677: clm_effective_date = x_po_header_record.clm_effective_date,
4678: clm_vendor_offer_number = x_po_header_record.clm_vendor_offer_number,

Line 4705: FROM po_headers_all

4701: END IF;
4702:
4703: SELECT UDA_TEMPLATE_ID
4704: INTO l_template_id
4705: FROM po_headers_all
4706: WHERE PO_HEADER_ID = p_from_pk_value;
4707:
4708: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Template id is ' || l_template_id);
4709:

Line 4827: FROM po_headers_all

4823:
4824:
4825: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
4826: INTO l_functional_area_code, l_document_type_code, l_document_style_id
4827: FROM po_headers_all
4828: WHERE PO_HEADER_ID = p_from_po_header_id;
4829:
4830: l_progress := '8881';
4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');

Line 4872: FROM po_headers_all_ext_b phaeb,

4868: --Bug 13482355
4869: BEGIN
4870: SELECT DISTINCT ags.ATTR_GROUP_NAME
4871: BULK COLLECT INTO l_ags_table
4872: FROM po_headers_all_ext_b phaeb,
4873: po_uda_ag_template_usages usages,
4874: ego_attr_groups_v ags
4875: WHERE phaeb.po_header_id = p_from_pk_value
4876: AND phaeb.draft_id=-1