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 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 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 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 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 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 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 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