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_CREATE_SR_ASL dependencies on PO_HEADERS_ALL

Line 36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

32: resultout out NOCOPY varchar2 ) IS
33: l_sr_organization_id number;
34: l_process_po varchar2(1);
35: x_progress varchar2(300);
36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

Line 40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
43: l_approved_flag varchar2(20);
44: l_start_date DATE;

Line 41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;

37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
43: l_approved_flag varchar2(20);
44: l_start_date DATE;
45: l_end_date DATE;

Line 156: po_headers_all ph

152: ph.vendor_id,
153: ph.vendor_site_id,
154: DECODE(ph.approved_flag,'Y','APPROVED',null)
155: FROM po_lines_all pl,
156: po_headers_all ph
157: WHERE pl.po_header_id = ph.po_header_id
158: AND ph.po_header_id = x_header_id
159: AND pl.item_id is not null
160: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 181: po_headers_all ph

177: ph.vendor_id,
178: ph.vendor_site_id,
179: DECODE(ph.approved_flag,'Y','APPROVED',null)
180: FROM po_lines_all pl,
181: po_headers_all ph
182: WHERE pl.po_header_id = ph.po_header_id
183: AND ph.po_header_id = x_header_id
184: AND pl.item_id is not null
185: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 249: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

245: l_interface_header_id NUMBER;
246: l_interface_line_id NUMBER;
247: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
248: l_category_id NUMBER;
249: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
250: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
251: l_document_type varchar2(25);
252: l_rel_gen_method varchar2(20);
253: l_sr_organization_id NUMBER;

Line 295: from po_headers_all

291: IF l_document_id is not null then
292:
293: select global_agreement_flag,vendor_site_id
294: into l_ga_flag , l_vendor_site_id
295: from po_headers_all
296: where po_header_id = l_document_id;
297:
298: END IF;
299:

Line 371: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;

367: x_progress VARCHAR2(300);
368: l_interface_header_id NUMBER;
369: l_interface_line_id NUMBER;
370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
371: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
372: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
374: l_document_type VARCHAR2(25);
375: l_approved_flag VARCHAR2(20);

Line 372: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;

368: l_interface_header_id NUMBER;
369: l_interface_line_id NUMBER;
370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
371: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
372: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
374: l_document_type VARCHAR2(25);
375: l_approved_flag VARCHAR2(20);
376: l_rule_name VARCHAR2(50);

Line 555: p_document_id IN PO_HEADERS_ALL.po_header_id%type,

551: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
555: p_document_id IN PO_HEADERS_ALL.po_header_id%type,
556: p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,
557: p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,
558: p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,
559: p_create_sourcing_rule IN VARCHAR2,

Line 556: p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,

552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
555: p_document_id IN PO_HEADERS_ALL.po_header_id%type,
556: p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,
557: p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,
558: p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,
559: p_create_sourcing_rule IN VARCHAR2,
560: p_update_sourcing_rule IN VARCHAR2,

Line 557: p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,

553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
555: p_document_id IN PO_HEADERS_ALL.po_header_id%type,
556: p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,
557: p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,
558: p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,
559: p_create_sourcing_rule IN VARCHAR2,
560: p_update_sourcing_rule IN VARCHAR2,
561: p_agreement_lines_selection IN VARCHAR2,

Line 558: p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,

554: x_msg_data OUT NOCOPY VARCHAR2,
555: p_document_id IN PO_HEADERS_ALL.po_header_id%type,
556: p_vendor_id IN PO_HEADERS_ALL.vendor_id%type,
557: p_purchasing_org_id IN PO_HEADERS_ALL.org_id%type,
558: p_vendor_site_id IN PO_HEADERS_ALL.vendor_site_id%type,
559: p_create_sourcing_rule IN VARCHAR2,
560: p_update_sourcing_rule IN VARCHAR2,
561: p_agreement_lines_selection IN VARCHAR2,
562: p_sourcing_level IN VARCHAR2,

Line 571: l_orgid PO_HEADERS_ALL.org_id%type;

567:
568: /* Local variables declared for Concurrent Program specific requirements */
569: l_archive_on_approve PO_DOCUMENT_TYPES_ALL.archive_external_revision_code%type;
570: l_previous_line_num PO_LINES_ALL.line_num%type;
571: l_orgid PO_HEADERS_ALL.org_id%type;
572:
573: /* Local variables Package specific information... Required for logging */
574: l_procedure_name varchar2(50):='create_autosource_rules : ';
575: l_progress VARCHAR2(2000);

Line 591: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;

587: l_start_date DATE;
588: l_end_date DATE;
589: l_create_update_flag VARCHAR2(20);
590: l_header_processable_flag VARCHAR2(1):='Y';
591: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE;
592: l_sourcing_level VARCHAR2(20);
593:
594: /* Local variables for API Standard Parameters */
595: l_api_version NUMBER :=1.0;

Line 621: po_headers_all ph

617: ph.end_date,
618: pl.item_id,
619: DECODE(ph.approved_flag,'Y','APPROVED',null)
620: FROM po_lines_all pl,
621: po_headers_all ph
622: WHERE pl.po_header_id = ph.po_header_id
623: AND ph.po_header_id = p_document_id
624: AND pl.item_id is not null
625: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 647: po_headers_all ph

643: ph.end_date,
644: pl.item_id,
645: DECODE(ph.approved_flag,'Y','APPROVED',null)
646: FROM po_lines_all pl,
647: po_headers_all ph
648: WHERE pl.po_header_id = ph.po_header_id
649: AND ph.po_header_id = p_document_id
650: AND pl.item_id is not null
651: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 778: po_headers_all poh

774: SELECT max(pola.line_num)
775: INTO l_previous_line_num
776: FROM
777: po_lines_archive_all pola,
778: po_headers_all poh
779: WHERE
780: poh.po_header_id=p_document_id
781: AND pola.po_header_id=poh.po_header_id
782: AND pola.revision_num < poh.revision_num ;

Line 1061: l_document_id PO_HEADERS_ALL.po_header_id%type;

1057: p_create_update_code IN VARCHAR2,
1058: p_interface_error_code IN VARCHAR2,
1059: x_header_processable_flag IN OUT NOCOPY VARCHAR2
1060: )IS
1061: l_document_id PO_HEADERS_ALL.po_header_id%type;
1062: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
1063: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1064: l_assignment_type_id NUMBER;
1065:

Line 1062: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

1058: p_interface_error_code IN VARCHAR2,
1059: x_header_processable_flag IN OUT NOCOPY VARCHAR2
1060: )IS
1061: l_document_id PO_HEADERS_ALL.po_header_id%type;
1062: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
1063: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1064: l_assignment_type_id NUMBER;
1065:
1066: /* Package specific information. Required for logging */

Line 1063: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;

1059: x_header_processable_flag IN OUT NOCOPY VARCHAR2
1060: )IS
1061: l_document_id PO_HEADERS_ALL.po_header_id%type;
1062: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;
1063: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1064: l_assignment_type_id NUMBER;
1065:
1066: /* Package specific information. Required for logging */
1067: l_procedure_name varchar2(50):='create_sourcing_rules_asl : ';

Line 1138: FROM po_headers_all

1134:
1135: IF p_document_id is not null THEN
1136: SELECT global_agreement_flag,vendor_site_id
1137: INTO l_ga_flag , l_vendor_site_id
1138: FROM po_headers_all
1139: WHERE po_header_id = p_document_id;
1140: END IF;
1141:
1142: IF g_po_pdoi_write_to_file ='Y' THEN