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 474: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||

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

Line 478: x_WF_ItemKey <> x_WF_ItemKey_save THEN

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

Line 486: FROM wf_items

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

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

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

Line 506: set wf_item_key = ''

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

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

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

Line 514: x_wf_itemkey,

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

Line 526: x_WF_ItemKey_Save := x_WF_ItemKey;

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

Line 720: x_WF_ItemKey VARCHAR2(100);

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

Line 721: x_WF_ItemKey_save VARCHAR2(100);

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

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

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

Line 735: x_WF_ItemKey := ' ';

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

Line 736: x_WF_ItemKey_save := ' ';

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

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

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

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

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

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

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

Line 844: x_WF_ItemKey <> x_WF_ItemKey_save THEN

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

Line 849: FROM wf_items

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

Line 866: x_wf_itemkey,

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

Line 877: x_WF_ItemKey_Save := x_WF_ItemKey;

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

Line 915: x_WF_ItemKey IN VARCHAR2,

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

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

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

Line 948: aname => 'WF_ITEM_KEY',

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

Line 1936: set wf_item_key = ''

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

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

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

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

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

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

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

Line 2222: itemkey => x_wf_itemkey,

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

Line 2260: x_WF_ItemKey VARCHAR2(100);

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

Line 2261: x_WF_ItemKey_save VARCHAR2(100);

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

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

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

Line 2272: x_WF_ItemKey := ' ';

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

Line 2273: x_WF_ItemKey_save := ' ';

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

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

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

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

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

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

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

Line 2342: x_WF_ItemKey <> x_WF_ItemKey_save THEN

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

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

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

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

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

Line 2351: x_WF_ItemKey);

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

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

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

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

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

Line 2365: itemkey => x_WF_ItemKey,

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

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

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

Line 2385: x_WF_ItemKey_Save := x_WF_ItemKey;

2381: END IF;
2382: END;
2383:
2384: -- Save the ItemKey for the next comparison
2385: x_WF_ItemKey_Save := x_WF_ItemKey;
2386:
2387: END IF;
2388:
2389:

Line 3355: l_item_type wf_items.item_type%TYPE;

3351: display_type in varchar2,
3352: document in out NOCOPY varchar2,
3353: document_type in out NOCOPY varchar2) IS
3354:
3355: l_item_type wf_items.item_type%TYPE;
3356: l_item_key wf_items.item_key%TYPE;
3357:
3358: l_document VARCHAR2(32000) := '';
3359: l_document_1 VARCHAR2(32000) := '';

Line 3356: l_item_key wf_items.item_key%TYPE;

3352: document in out NOCOPY varchar2,
3353: document_type in out NOCOPY varchar2) IS
3354:
3355: l_item_type wf_items.item_type%TYPE;
3356: l_item_key wf_items.item_key%TYPE;
3357:
3358: l_document VARCHAR2(32000) := '';
3359: l_document_1 VARCHAR2(32000) := '';
3360: l_document_2 VARCHAR2(32000) := '';

Line 3667: -- Get the wf_item_key item attribute value

3663: end if;
3664:
3665: -- update the distribution data only if the skip validation param is not Y
3666: if (skip_distribution_updation <> 'Y') then
3667: -- Get the wf_item_key item attribute value
3668: conf_item_key := PO_WF_UTIL_PKG.GetItemAttrText(
3669: itemtype => itemtype,
3670: itemkey => itemkey,
3671: aname => 'WF_ITEM_KEY');

Line 3671: aname => 'WF_ITEM_KEY');

3667: -- Get the wf_item_key item attribute value
3668: conf_item_key := PO_WF_UTIL_PKG.GetItemAttrText(
3669: itemtype => itemtype,
3670: itemkey => itemkey,
3671: aname => 'WF_ITEM_KEY');
3672:
3673: -- Update the PO_DISTRIBUTIONS_ALL table with this
3674: -- item key value and qty invoiced value
3675: UPDATE PO_DISTRIBUTIONS_ALL

Line 3676: SET WF_ITEM_KEY = conf_item_key,

3672:
3673: -- Update the PO_DISTRIBUTIONS_ALL table with this
3674: -- item key value and qty invoiced value
3675: UPDATE PO_DISTRIBUTIONS_ALL
3676: SET WF_ITEM_KEY = conf_item_key,
3677: invoiced_val_in_ntfn = x_qty_inv
3678: WHERE po_distribution_id = x_dist_id;
3679: end if;
3680:

Line 3807: AND wf_item_key = itemKey;

3803: null,
3804: null
3805: FROM POR_RCV_ALL_ITEMS_V1
3806: WHERE po_header_ID = x_po_header_ID
3807: AND wf_item_key = itemKey;
3808:
3809: FETCH porcpt_Shipment BULK COLLECT into t_po_header_id,
3810: t_line_location_id,
3811: t_expected_receipt_qty,

Line 3867: set wf_item_key = ''

3863: RESULT := 'PASSED';
3864:
3865: -- Clean the po distribtions table
3866: update po_distributions
3867: set wf_item_key = ''
3868: where wf_item_key = itemKey;
3869:
3870: ELSE
3871: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);

Line 3868: where wf_item_key = itemKey;

3864:
3865: -- Clean the po distribtions table
3866: update po_distributions
3867: set wf_item_key = ''
3868: where wf_item_key = itemKey;
3869:
3870: ELSE
3871: get_txn_error_message(x_group_id, x_RCV_txns_rc, x_rcv_trans_status, x_message_token);
3872:

Line 3916: x_WF_ItemKey varchar2(240);

3912: x_po_header_id number;
3913: x_requester_id number;
3914: x_sys_date date;
3915: x_exp_receipt_date date;
3916: x_WF_ItemKey varchar2(240);
3917: x_revision_num number;
3918: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
3919: BEGIN
3920: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

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

3940: into x_sys_date
3941: from dual;
3942:
3943: -- Create a new item key
3944: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
3945: to_char(x_requester_id) || ';' ||
3946: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
3947:
3948: -- Start the Rcpt Process with the new item key

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

3946: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');
3947:
3948: -- Start the Rcpt Process with the new item key
3949: Start_Rcpt_Process(x_po_header_id, x_requester_id, x_exp_receipt_date,
3950: x_WF_ItemKey, x_revision_num, 'N', '-1', x_po_num_rel_num);
3951:
3952: END Restart_rcpt_process;
3953:
3954: /*===========================================================================