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_LINES

Line 28: procedure PROCESS_PO_LINES_FOR_SR_ASL( itemtype in varchar2,

24: | additional parameter to identify interface errors generated
25: | by calls from WF
26: *=======================================================================*/
27:
28: procedure PROCESS_PO_LINES_FOR_SR_ASL( itemtype in varchar2,
29: itemkey in varchar2,
30: actid in number,
31: funcmode in varchar2,
32: resultout out NOCOPY varchar2 ) IS

Line 37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;

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;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;

Line 38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;

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;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

Line 39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;

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

Line 42: l_item_id PO_LINES_ALL.ITEM_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;
46: l_interface_header_id NUMBER;

Line 51: x_progress := 'PO_CREATE_SR_ASL:PROCESS_PO_LINES_FOR_SR_ASL: 01';

47: l_interface_line_id NUMBER;
48: l_org_assign_change VARCHAR2(1);
49:
50: BEGIN
51: x_progress := 'PO_CREATE_SR_ASL:PROCESS_PO_LINES_FOR_SR_ASL: 01';
52: IF (g_po_wf_debug = 'Y') THEN
53: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
54: END IF;
55:

Line 128: END PROCESS_PO_LINES_FOR_SR_ASL;

124: x_progress := ': 03. Result= ' || l_process_po;
125: --PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
126: resultout := wf_engine.eng_completed || ':' || l_process_po;
127:
128: END PROCESS_PO_LINES_FOR_SR_ASL;
129:
130: PROCEDURE GET_LINE_FOR_PROCESS
131: (
132: x_header_id IN NUMBER, -- PO Header ID

Line 155: FROM po_lines_all pl,

151: pl.item_id,
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

Line 164: FROM po_lines_archive pla

160: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
161: AND nvl(pl.cancel_flag,'N') = 'N'
162: AND NOT EXISTS
163: (SELECT 'Line included in Prior Revision'
164: FROM po_lines_archive pla
165: WHERE pla.po_line_id = pl.po_line_id
166: AND pla.revision_num < ph.revision_num)
167: AND pl.line_num > x_prev_line_num
168: ORDER BY ph.po_header_id, pl.line_num;

Line 180: FROM po_lines_all pl,

176: pl.item_id,
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

Line 247: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

243: l_create_asl varchar2(2);
244: x_progress varchar2(300);
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);

Line 250: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

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;
254: l_header_processable_flag varchar2(1);

Line 370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

366: l_create_sr VARCHAR2(2);
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);

Line 373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

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);
377: l_rule_prefix VARCHAR2(20);

Line 570: l_previous_line_num PO_LINES_ALL.line_num%type;

566: p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type) IS
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 : ';

Line 582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

578: l_interface_header_id NUMBER;
579: l_interface_line_id NUMBER;
580: l_document_type_code VARCHAR2(10):= 'PA';
581: l_document_subtype VARCHAR2(10):= 'BLANKET';
582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
583: l_category_id NUMBER;
584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
585: l_approved_flag VARCHAR2(20);
586: l_rule_prefix VARCHAR2(20);

Line 584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

580: l_document_type_code VARCHAR2(10):= 'PA';
581: l_document_subtype VARCHAR2(10):= 'BLANKET';
582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
583: l_category_id NUMBER;
584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
585: l_approved_flag VARCHAR2(20);
586: l_rule_prefix VARCHAR2(20);
587: l_start_date DATE;
588: l_end_date DATE;

Line 620: FROM po_lines_all pl,

616: ph.start_date,
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

Line 629: FROM po_lines_archive pla

625: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
626: AND nvl(pl.cancel_flag,'N') = 'N'
627: /* AND NOT EXISTS
628: (SELECT 'Line included in Prior Revision'
629: FROM po_lines_archive pla
630: WHERE pla.po_line_id = pl.po_line_id
631: AND pla.revision_num < ph.revision_num)*/
632: AND pl.line_num > l_previous_line_num
633: ORDER BY ph.po_header_id, pl.line_num;

Line 646: FROM po_lines_all pl,

642: ph.start_date,
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

Line 777: po_lines_archive_all pola,

773: -- SQL Join: po_header_id
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

Line 1040: p_interface_line_id IN PO_LINES_INTERFACE.interface_line_id%type,

1036: x_return_status OUT NOCOPY VARCHAR2,
1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2,
1039: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%type,
1040: p_interface_line_id IN PO_LINES_INTERFACE.interface_line_id%type,
1041: p_document_id IN PO_HEADERS.po_header_id%type,
1042: p_po_line_id IN PO_LINES.po_line_id%type,
1043: p_document_type IN PO_HEADERS.type_lookup_code%type,
1044: p_approval_status IN VARCHAR2,

Line 1042: p_po_line_id IN PO_LINES.po_line_id%type,

1038: x_msg_data OUT NOCOPY VARCHAR2,
1039: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%type,
1040: p_interface_line_id IN PO_LINES_INTERFACE.interface_line_id%type,
1041: p_document_id IN PO_HEADERS.po_header_id%type,
1042: p_po_line_id IN PO_LINES.po_line_id%type,
1043: p_document_type IN PO_HEADERS.type_lookup_code%type,
1044: p_approval_status IN VARCHAR2,
1045: p_vendor_id IN PO_HEADERS.vendor_id%type,
1046: p_vendor_site_id IN PO_HEADERS.vendor_site_id%type,