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 648: po_headers_all ph

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

Line 780: po_headers_all poh

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

Line 1063: l_document_id PO_HEADERS_ALL.po_header_id%type;

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

Line 1064: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%type;

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

Line 1065: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;

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

Line 1140: FROM po_headers_all

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

Line 1238: l_vendor_id PO_HEADERS_ALL.vendor_id%type;

1234: actid in number,
1235: funcmode in varchar2,
1236: resultout out NOCOPY varchar2 ) is
1237:
1238: l_vendor_id PO_HEADERS_ALL.vendor_id%type;
1239: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1240: l_document_id PO_HEADERS_ALL.po_header_id%type;
1241: l_release_generation_method PO_ASL_ATTRIBUTES.release_generation_method%type;
1242: l_api_version NUMBER :=1.0;

Line 1239: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;

1235: funcmode in varchar2,
1236: resultout out NOCOPY varchar2 ) is
1237:
1238: l_vendor_id PO_HEADERS_ALL.vendor_id%type;
1239: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1240: l_document_id PO_HEADERS_ALL.po_header_id%type;
1241: l_release_generation_method PO_ASL_ATTRIBUTES.release_generation_method%type;
1242: l_api_version NUMBER :=1.0;
1243: l_init_msg_list VARCHAR2(5) :=FND_API.G_FALSE;

Line 1240: l_document_id PO_HEADERS_ALL.po_header_id%type;

1236: resultout out NOCOPY varchar2 ) is
1237:
1238: l_vendor_id PO_HEADERS_ALL.vendor_id%type;
1239: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type;
1240: l_document_id PO_HEADERS_ALL.po_header_id%type;
1241: l_release_generation_method PO_ASL_ATTRIBUTES.release_generation_method%type;
1242: l_api_version NUMBER :=1.0;
1243: l_init_msg_list VARCHAR2(5) :=FND_API.G_FALSE;
1244: l_commit VARCHAR2(5) :=FND_API.G_FALSE;

Line 1269: from po_headers_all

1265:
1266: begin
1267: select vendor_id, vendor_site_id
1268: into l_vendor_id, l_vendor_site_id
1269: from po_headers_all
1270: where po_header_id = l_document_id;
1271: exception
1272: when no_data_found then
1273: l_vendor_id := null;