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.PORCPTWF dependencies on WF_ITEM

Line 337: x_WF_ItemKey VARCHAR2(100);

333: x_po_header_id NUMBER;
334: x_po_distribution_id NUMBER;
335: x_requester_id NUMBER;
336: x_exp_receipt_date DATE;
337: x_WF_ItemKey VARCHAR2(100);
338: x_WF_ItemKey_save VARCHAR2(100);
339: x_auto_receive_flag VARCHAR2(1);
340: x_WF_process_exists BOOLEAN;
341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

Line 338: x_WF_ItemKey_save VARCHAR2(100);

334: x_po_distribution_id NUMBER;
335: x_requester_id NUMBER;
336: x_exp_receipt_date DATE;
337: x_WF_ItemKey VARCHAR2(100);
338: x_WF_ItemKey_save VARCHAR2(100);
339: x_auto_receive_flag VARCHAR2(1);
340: x_WF_process_exists BOOLEAN;
341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
342: x_wf_itemtype varchar2(6) := 'PORCPT';

Line 342: x_wf_itemtype varchar2(6) := 'PORCPT';

338: x_WF_ItemKey_save VARCHAR2(100);
339: x_auto_receive_flag VARCHAR2(1);
340: x_WF_process_exists BOOLEAN;
341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
342: x_wf_itemtype varchar2(6) := 'PORCPT';
343: x_revision_num number;
344: x_internal_req_rcpt Varchar2(1) := FND_PROFILE.value('POR_INTERNAL_CONFIRM_RECEIPT');
345: x_sys_date DATE;
346: x_item_key_count number;

Line 351: x_WF_ItemKey := ' ';

347: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
348:
349: BEGIN
350:
351: x_WF_ItemKey := ' ';
352: x_WF_ItemKey_save := ' ';
353:
354: -- Call WF purge API to remove any existing Confirm Receipts WF items
355: -- which are completed with an END_DATE less than or equal to

Line 352: x_WF_ItemKey_save := ' ';

348:
349: BEGIN
350:
351: x_WF_ItemKey := ' ';
352: x_WF_ItemKey_save := ' ';
353:
354: -- Call WF purge API to remove any existing Confirm Receipts WF items
355: -- which are completed with an END_DATE less than or equal to
356: -- SYSDATE (default). This is to ensure that the Selection

Line 354: -- Call WF purge API to remove any existing Confirm Receipts WF items

350:
351: x_WF_ItemKey := ' ';
352: x_WF_ItemKey_save := ' ';
353:
354: -- Call WF purge API to remove any existing Confirm Receipts WF items
355: -- which are completed with an END_DATE less than or equal to
356: -- SYSDATE (default). This is to ensure that the Selection
357: -- process can start the workflow process for the same item key value.
358: --

Line 359: -- The WF purge API will not remove any WF items which are still

355: -- which are completed with an END_DATE less than or equal to
356: -- SYSDATE (default). This is to ensure that the Selection
357: -- process can start the workflow process for the same item key value.
358: --
359: -- The WF purge API will not remove any WF items which are still
360: -- opened with END_DATE = NULL;
361:
362:
363: WF_PURGE.total ('PORCPT');

Line 476: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||

472: x_exp_receipt_date);
473: ELSE
474: select sysdate into x_sys_date from dual;
475:
476: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
477: to_char(x_requester_id) || ';' ||
478: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
479: IF Porcpt_c%FOUND AND
480: x_WF_ItemKey <> x_WF_ItemKey_save THEN

Line 480: x_WF_ItemKey <> x_WF_ItemKey_save THEN

476: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
477: to_char(x_requester_id) || ';' ||
478: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
479: IF Porcpt_c%FOUND AND
480: x_WF_ItemKey <> x_WF_ItemKey_save THEN
481:
482: --
483:
484: -- Requirement - We should not send the notification if

Line 488: FROM wf_items

484: -- Requirement - We should not send the notification if
485: -- there are any active processes for the po_header_id and
486: -- requester_id combination.
487: SELECT count(1) into x_item_key_count
488: FROM wf_items
489: WHERE item_type = 'PORCPT'
490: AND item_key like x_po_header_id||';'|| x_requester_id||';%'
491: AND END_DATE is null;
492:

Line 504: -- set the wf_item_key column with null value

500:
501: --
502:
503: -- Clean the po distribtions table
504: -- set the wf_item_key column with null value
505: -- if there are any existing distribtion lines with
506: -- old match.
507: update po_distributions
508: set wf_item_key = ''

Line 508: set wf_item_key = ''

504: -- set the wf_item_key column with null value
505: -- if there are any existing distribtion lines with
506: -- old match.
507: update po_distributions
508: set wf_item_key = ''
509: where po_header_id = x_po_header_ID
510: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
511:
512: --

Line 510: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';

506: -- old match.
507: update po_distributions
508: set wf_item_key = ''
509: where po_header_id = x_po_header_ID
510: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
511:
512: --
513: PORCPTWF.Start_Rcpt_Process(x_po_header_id,
514: x_requester_id,

Line 516: x_wf_itemkey,

512: --
513: PORCPTWF.Start_Rcpt_Process(x_po_header_id,
514: x_requester_id,
515: x_exp_receipt_date,
516: x_wf_itemkey,
517: x_revision_num,
518: 'N',
519: '-1',
520: x_po_num_rel_num);

Line 528: x_WF_ItemKey_Save := x_WF_ItemKey;

524:
525: END IF;
526:
527: -- Save the ItemKey for the next comparison
528: x_WF_ItemKey_Save := x_WF_ItemKey;
529:
530: END IF;
531:
532: END IF;

Line 722: x_WF_ItemKey VARCHAR2(100);

718: --po_header_id NUMBER;
719: --po_distribution_id NUMBER;
720: x_requester_id NUMBER;
721: x_exp_receipt_date DATE;
722: x_WF_ItemKey VARCHAR2(100);
723: x_WF_ItemKey_save VARCHAR2(100);
724: x_auto_receive_flag VARCHAR2(1);
725: x_WF_process_exists BOOLEAN;
726: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

Line 723: x_WF_ItemKey_save VARCHAR2(100);

719: --po_distribution_id NUMBER;
720: x_requester_id NUMBER;
721: x_exp_receipt_date DATE;
722: x_WF_ItemKey VARCHAR2(100);
723: x_WF_ItemKey_save VARCHAR2(100);
724: x_auto_receive_flag VARCHAR2(1);
725: x_WF_process_exists BOOLEAN;
726: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
727: ssp_version VARCHAR2(30) := FND_PROFILE.value('POR_SSP_VERSION');

Line 729: x_wf_itemtype varchar2(6) := 'PORCPT';

725: x_WF_process_exists BOOLEAN;
726: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
727: ssp_version VARCHAR2(30) := FND_PROFILE.value('POR_SSP_VERSION');
728: x_ssp_version_gt4 VARCHAR2(10) := 'Y';
729: x_wf_itemtype varchar2(6) := 'PORCPT';
730: x_revision_num number;
731: x_item_key_count number;
732:
733: BEGIN

Line 737: x_WF_ItemKey := ' ';

733: BEGIN
734:
735: po_debug.set_file_io(true);
736:
737: x_WF_ItemKey := ' ';
738: x_WF_ItemKey_save := ' ';
739:
740: -- Call WF purge API to remove any existing Confirm Receipts WF items
741: -- which are completed with an END_DATE less than or equal to

Line 738: x_WF_ItemKey_save := ' ';

734:
735: po_debug.set_file_io(true);
736:
737: x_WF_ItemKey := ' ';
738: x_WF_ItemKey_save := ' ';
739:
740: -- Call WF purge API to remove any existing Confirm Receipts WF items
741: -- which are completed with an END_DATE less than or equal to
742: -- SYSDATE (default). This is to ensure that the Selection

Line 740: -- Call WF purge API to remove any existing Confirm Receipts WF items

736:
737: x_WF_ItemKey := ' ';
738: x_WF_ItemKey_save := ' ';
739:
740: -- Call WF purge API to remove any existing Confirm Receipts WF items
741: -- which are completed with an END_DATE less than or equal to
742: -- SYSDATE (default). This is to ensure that the Selection
743: -- process can start the workflow process for the same item key value.
744: --

Line 745: -- The WF purge API will not remove any WF items which are still

741: -- which are completed with an END_DATE less than or equal to
742: -- SYSDATE (default). This is to ensure that the Selection
743: -- process can start the workflow process for the same item key value.
744: --
745: -- The WF purge API will not remove any WF items which are still
746: -- opened with END_DATE = NULL;
747:
748:
749: WF_PURGE.total ('PORCPT');

Line 841: x_WF_ItemKey := to_char(x_header_id) || ';' ||

837: ELSE
838:
839: --ash_debug.debug('select order :auto rec else loop 2',x_auto_receive_flag);
840:
841: x_WF_ItemKey := to_char(x_header_id) || ';' ||
842: to_char(x_requester_id) || ';' ||
843: to_char(x_exp_receipt_date,'DD-MON-YYYY');
844:
845: IF Porcpt_c%FOUND AND

Line 846: x_WF_ItemKey <> x_WF_ItemKey_save THEN

842: to_char(x_requester_id) || ';' ||
843: to_char(x_exp_receipt_date,'DD-MON-YYYY');
844:
845: IF Porcpt_c%FOUND AND
846: x_WF_ItemKey <> x_WF_ItemKey_save THEN
847:
848: -- Check if there is any active workflow process running
849: -- for the so_header_id and requester_id combination
850: SELECT count(1) into x_item_key_count

Line 851: FROM wf_items

847:
848: -- Check if there is any active workflow process running
849: -- for the so_header_id and requester_id combination
850: SELECT count(1) into x_item_key_count
851: FROM wf_items
852: WHERE item_type = 'PORCPT'
853: AND item_key like x_header_id||';'|| x_requester_id||';%'
854: AND END_DATE is null;
855:

Line 868: x_wf_itemkey,

864:
865: PORCPTWF.Start_Rcpt_Process(x_header_id,
866: x_requester_id,
867: x_exp_receipt_date,
868: x_wf_itemkey,
869: x_revision_num,
870: 'Y',
871: x_requisition_header_id);
872:

Line 879: x_WF_ItemKey_Save := x_WF_ItemKey;

875:
876: END IF;
877:
878: -- Save the ItemKey for the next comparison
879: x_WF_ItemKey_Save := x_WF_ItemKey;
880:
881: END IF;
882:
883: END IF;

Line 917: x_WF_ItemKey IN VARCHAR2,

913:
914: PROCEDURE Start_Rcpt_Process (x_header_id IN NUMBER,
915: x_requester_id IN NUMBER,
916: x_exp_receipt_date IN DATE,
917: x_WF_ItemKey IN VARCHAR2,
918: x_revision_num IN NUMBER,
919: x_is_int_req IN VARCHAR2 default 'N',
920: x_req_header_id IN NUMBER default '-1',
921: x_po_num_rel_num IN VARCHAR2 default null) IS

Line 925: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;

921: x_po_num_rel_num IN VARCHAR2 default null) IS
922:
923:
924: l_ItemType VARCHAR2(100) := 'PORCPT';
925: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
926:
927: x_requester_username WF_USERS.NAME%TYPE;
928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_username WF_USERS.NAME%TYPE;

Line 950: aname => 'WF_ITEM_KEY',

946: -- ash_debug.debug('Start_Rcpt_Process','1');
947:
948: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_ItemType,
949: itemkey => l_itemkey,
950: aname => 'WF_ITEM_KEY',
951: avalue => l_ItemKey);
952:
953: x_org_id := findOrgId(x_header_id,x_is_int_req);
954:

Line 1939: set wf_item_key = ''

1935: x_RCV_txns_rc = 0 THEN
1936:
1937: -- Clean the po distribtions table
1938: update po_distributions
1939: set wf_item_key = ''
1940: where po_header_id = x_po_header_ID
1941: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
1942:
1943: RESULT := 'PASSED';

Line 1941: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';

1937: -- Clean the po distribtions table
1938: update po_distributions
1939: set wf_item_key = ''
1940: where po_header_id = x_po_header_ID
1941: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
1942:
1943: RESULT := 'PASSED';
1944:
1945: ELSE

Line 2217: function po_revised ( x_po_header_id IN number , x_revision_num IN number,x_wf_itemtype IN varchar2 ,x_wf_itemkey IN varchar2)

2213: end if;
2214:
2215: END findOrgId;
2216:
2217: function po_revised ( x_po_header_id IN number , x_revision_num IN number,x_wf_itemtype IN varchar2 ,x_wf_itemkey IN varchar2)
2218: return boolean is
2219: old_rev_num number;
2220: x_item_exists varchar2(1) := 'Y';
2221: begin

Line 2224: old_rev_num := wf_engine.GetItemAttrNumber ( itemtype => x_wf_itemtype,

2220: x_item_exists varchar2(1) := 'Y';
2221: begin
2222: begin
2223: /** get the attribute for that notification.**/
2224: old_rev_num := wf_engine.GetItemAttrNumber ( itemtype => x_wf_itemtype,
2225: itemkey => x_wf_itemkey,
2226: aname => 'PO_REVISION_NUM');
2227: x_item_exists := 'Y';
2228: exception

Line 2225: itemkey => x_wf_itemkey,

2221: begin
2222: begin
2223: /** get the attribute for that notification.**/
2224: old_rev_num := wf_engine.GetItemAttrNumber ( itemtype => x_wf_itemtype,
2225: itemkey => x_wf_itemkey,
2226: aname => 'PO_REVISION_NUM');
2227: x_item_exists := 'Y';
2228: exception
2229: when others then

Line 2263: x_WF_ItemKey VARCHAR2(100);

2259:
2260: x_po_header_id NUMBER;
2261: x_requester_id NUMBER;
2262: x_exp_receipt_date DATE;
2263: x_WF_ItemKey VARCHAR2(100);
2264: x_WF_ItemKey_save VARCHAR2(100);
2265: x_auto_receive_flag VARCHAR2(1);
2266: x_WF_process_exists BOOLEAN;
2267: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

Line 2264: x_WF_ItemKey_save VARCHAR2(100);

2260: x_po_header_id NUMBER;
2261: x_requester_id NUMBER;
2262: x_exp_receipt_date DATE;
2263: x_WF_ItemKey VARCHAR2(100);
2264: x_WF_ItemKey_save VARCHAR2(100);
2265: x_auto_receive_flag VARCHAR2(1);
2266: x_WF_process_exists BOOLEAN;
2267: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2268:

Line 2269: x_wf_itemtype varchar2(6) := 'PORCPT';

2265: x_auto_receive_flag VARCHAR2(1);
2266: x_WF_process_exists BOOLEAN;
2267: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2268:
2269: x_wf_itemtype varchar2(6) := 'PORCPT';
2270: x_revision_num number;
2271:
2272: BEGIN
2273:

Line 2275: x_WF_ItemKey := ' ';

2271:
2272: BEGIN
2273:
2274:
2275: x_WF_ItemKey := ' ';
2276: x_WF_ItemKey_save := ' ';
2277:
2278: -- Call WF purge API to remove any existing Confirm Receipts WF items
2279: -- which are completed with an END_DATE less than or equal to

Line 2276: x_WF_ItemKey_save := ' ';

2272: BEGIN
2273:
2274:
2275: x_WF_ItemKey := ' ';
2276: x_WF_ItemKey_save := ' ';
2277:
2278: -- Call WF purge API to remove any existing Confirm Receipts WF items
2279: -- which are completed with an END_DATE less than or equal to
2280: -- SYSDATE (default). This is to ensure that the Selection

Line 2278: -- Call WF purge API to remove any existing Confirm Receipts WF items

2274:
2275: x_WF_ItemKey := ' ';
2276: x_WF_ItemKey_save := ' ';
2277:
2278: -- Call WF purge API to remove any existing Confirm Receipts WF items
2279: -- which are completed with an END_DATE less than or equal to
2280: -- SYSDATE (default). This is to ensure that the Selection
2281: -- process can start the workflow process for the same item key value.
2282: --

Line 2283: -- The WF purge API will not remove any WF items which are still

2279: -- which are completed with an END_DATE less than or equal to
2280: -- SYSDATE (default). This is to ensure that the Selection
2281: -- process can start the workflow process for the same item key value.
2282: --
2283: -- The WF purge API will not remove any WF items which are still
2284: -- opened with END_DATE = NULL;
2285:
2286:
2287: WF_PURGE.total ('PORCPT');

Line 2340: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||

2336: --
2337:
2338:
2339:
2340: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
2341: to_char(x_requester_id) || ';' ||
2342: to_char(x_exp_receipt_date,'DD-MON-YYYY');
2343:
2344: IF Porcpt_c%FOUND AND

Line 2345: x_WF_ItemKey <> x_WF_ItemKey_save THEN

2341: to_char(x_requester_id) || ';' ||
2342: to_char(x_exp_receipt_date,'DD-MON-YYYY');
2343:
2344: IF Porcpt_c%FOUND AND
2345: x_WF_ItemKey <> x_WF_ItemKey_save THEN
2346:
2347: begin
2348:
2349: -- Call Workflow to check if the itemkey already exists

Line 2350: -- Note: WF_item.item_exist is for internal use. This procedure

2346:
2347: begin
2348:
2349: -- Call Workflow to check if the itemkey already exists
2350: -- Note: WF_item.item_exist is for internal use. This procedure
2351: -- will be replaced by an API in a later Workflow release.
2352:
2353: x_WF_process_exists := WF_item.item_exist ('PORCPT',
2354: x_WF_ItemKey);

Line 2353: x_WF_process_exists := WF_item.item_exist ('PORCPT',

2349: -- Call Workflow to check if the itemkey already exists
2350: -- Note: WF_item.item_exist is for internal use. This procedure
2351: -- will be replaced by an API in a later Workflow release.
2352:
2353: x_WF_process_exists := WF_item.item_exist ('PORCPT',
2354: x_WF_ItemKey);
2355:
2356: IF x_WF_process_exists THEN
2357:

Line 2354: x_WF_ItemKey);

2350: -- Note: WF_item.item_exist is for internal use. This procedure
2351: -- will be replaced by an API in a later Workflow release.
2352:
2353: x_WF_process_exists := WF_item.item_exist ('PORCPT',
2354: x_WF_ItemKey);
2355:
2356: IF x_WF_process_exists THEN
2357:
2358: -- Workflow item exists and is still opened

Line 2365: if po_revised(x_po_header_id, x_revision_num , x_wf_itemtype,x_WF_ItemKey ) then

2361:
2362: /** If the revision number of the PO is different then cancel the
2363: open notifications ; we need to remove the ELSE below since we
2364: need to start_recpt_process for such cases too. **/
2365: if po_revised(x_po_header_id, x_revision_num , x_wf_itemtype,x_WF_ItemKey ) then
2366: --This will abort and purge the process
2367: wf_purge.items(itemtype => x_WF_ItemType,
2368: itemkey => x_WF_ItemKey,
2369: enddate => sysdate,

Line 2367: wf_purge.items(itemtype => x_WF_ItemType,

2363: open notifications ; we need to remove the ELSE below since we
2364: need to start_recpt_process for such cases too. **/
2365: if po_revised(x_po_header_id, x_revision_num , x_wf_itemtype,x_WF_ItemKey ) then
2366: --This will abort and purge the process
2367: wf_purge.items(itemtype => x_WF_ItemType,
2368: itemkey => x_WF_ItemKey,
2369: enddate => sysdate,
2370: docommit => true,
2371: force => true);

Line 2368: itemkey => x_WF_ItemKey,

2364: need to start_recpt_process for such cases too. **/
2365: if po_revised(x_po_header_id, x_revision_num , x_wf_itemtype,x_WF_ItemKey ) then
2366: --This will abort and purge the process
2367: wf_purge.items(itemtype => x_WF_ItemType,
2368: itemkey => x_WF_ItemKey,
2369: enddate => sysdate,
2370: docommit => true,
2371: force => true);
2372:

Line 2383: po_wf_debug_pkg.insert_debug(x_wf_itemtype,x_wf_itemkey,'purge_orders SQL error ' || sqlcode || ' error message: ' || substr(sqlerrm,1,512));

2379: EXCEPTION
2380: when others then
2381: wf_core.context ('PORCPTWF','purge_Orders','SQL error ' || sqlcode);
2382: IF (g_po_wf_debug = 'Y') THEN
2383: po_wf_debug_pkg.insert_debug(x_wf_itemtype,x_wf_itemkey,'purge_orders SQL error ' || sqlcode || ' error message: ' || substr(sqlerrm,1,512));
2384: END IF;
2385: END;
2386:
2387: -- Save the ItemKey for the next comparison

Line 2388: x_WF_ItemKey_Save := x_WF_ItemKey;

2384: END IF;
2385: END;
2386:
2387: -- Save the ItemKey for the next comparison
2388: x_WF_ItemKey_Save := x_WF_ItemKey;
2389:
2390: END IF;
2391:
2392:

Line 3400: l_item_type wf_items.item_type%TYPE;

3396: display_type in varchar2,
3397: document in out NOCOPY varchar2,
3398: document_type in out NOCOPY varchar2) IS
3399:
3400: l_item_type wf_items.item_type%TYPE;
3401: l_item_key wf_items.item_key%TYPE;
3402:
3403: l_document VARCHAR2(32000) := '';
3404: l_document_1 VARCHAR2(32000) := '';

Line 3401: l_item_key wf_items.item_key%TYPE;

3397: document in out NOCOPY varchar2,
3398: document_type in out NOCOPY varchar2) IS
3399:
3400: l_item_type wf_items.item_type%TYPE;
3401: l_item_key wf_items.item_key%TYPE;
3402:
3403: l_document VARCHAR2(32000) := '';
3404: l_document_1 VARCHAR2(32000) := '';
3405: l_document_2 VARCHAR2(32000) := '';

Line 3719: -- Get the wf_item_key item attribute value

3715: end if;
3716:
3717: -- update the distribution data only if the skip validation param is not Y
3718: if (skip_distribution_updation <> 'Y') then
3719: -- Get the wf_item_key item attribute value
3720: conf_item_key := PO_WF_UTIL_PKG.GetItemAttrText(
3721: itemtype => itemtype,
3722: itemkey => itemkey,
3723: aname => 'WF_ITEM_KEY');

Line 3723: aname => 'WF_ITEM_KEY');

3719: -- Get the wf_item_key item attribute value
3720: conf_item_key := PO_WF_UTIL_PKG.GetItemAttrText(
3721: itemtype => itemtype,
3722: itemkey => itemkey,
3723: aname => 'WF_ITEM_KEY');
3724:
3725: -- Update the PO_DISTRIBUTIONS_ALL table with this
3726: -- item key value and qty invoiced value
3727: UPDATE PO_DISTRIBUTIONS_ALL

Line 3728: SET WF_ITEM_KEY = conf_item_key,

3724:
3725: -- Update the PO_DISTRIBUTIONS_ALL table with this
3726: -- item key value and qty invoiced value
3727: UPDATE PO_DISTRIBUTIONS_ALL
3728: SET WF_ITEM_KEY = conf_item_key,
3729: invoiced_val_in_ntfn = x_qty_inv
3730: WHERE po_distribution_id = x_dist_id;
3731: end if;
3732:

Line 3867: AND wf_item_key = itemKey;

3863: null,
3864: null
3865: FROM POR_RCV_ALL_ITEMS_V1
3866: WHERE po_header_ID = x_po_header_ID
3867: AND wf_item_key = itemKey;
3868:
3869: FETCH porcpt_Shipment BULK COLLECT into t_po_header_id,
3870: t_line_location_id,
3871: t_expected_receipt_qty,

Line 3927: set wf_item_key = ''

3923: RESULT := 'PASSED';
3924:
3925: -- Clean the po distribtions table
3926: update po_distributions
3927: set wf_item_key = ''
3928: where wf_item_key = itemKey;
3929:
3930: ELSE
3931: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);

Line 3928: where wf_item_key = itemKey;

3924:
3925: -- Clean the po distribtions table
3926: update po_distributions
3927: set wf_item_key = ''
3928: where wf_item_key = itemKey;
3929:
3930: ELSE
3931: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
3932:

Line 3976: x_WF_ItemKey varchar2(240);

3972: x_po_header_id number;
3973: x_requester_id number;
3974: x_sys_date date;
3975: x_exp_receipt_date date;
3976: x_WF_ItemKey varchar2(240);
3977: x_revision_num number;
3978: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
3979: BEGIN
3980: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 4004: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||

4000: into x_sys_date
4001: from dual;
4002:
4003: -- Create a new item key
4004: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
4005: to_char(x_requester_id) || ';' ||
4006: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
4007:
4008: -- Start the Rcpt Process with the new item key

Line 4010: x_WF_ItemKey, x_revision_num, 'N', '-1', x_po_num_rel_num);

4006: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
4007:
4008: -- Start the Rcpt Process with the new item key
4009: Start_Rcpt_Process(x_po_header_id, x_requester_id, x_exp_receipt_date,
4010: x_WF_ItemKey, x_revision_num, 'N', '-1', x_po_num_rel_num);
4011:
4012: END Restart_rcpt_process;
4013:
4014: /*===========================================================================