247: aname => 'RESPONSIBILITY_ID',
248: avalue => l_responsibility_id);
249:
250: /* Set the context for the doc manager */
251: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
252: end if;
253:
254: IF (g_asn_debug = 'Y') THEN
255: debug_log(FND_LOG.LEVEL_STATEMENT,
896: p_request_id => 0,
897: p_program_application_id => 0,
898: p_program_id =>0 ,
899: p_program_date => sysdate ,
900: p_user_id => fnd_global.user_id ,
901: p_login_id => fnd_global.login_id);
902:
903: ELSE --}{
904: l_sequence_num := l_sequence_num - 1;
897: p_program_application_id => 0,
898: p_program_id =>0 ,
899: p_program_date => sysdate ,
900: p_user_id => fnd_global.user_id ,
901: p_login_id => fnd_global.login_id);
902:
903: ELSE --}{
904: l_sequence_num := l_sequence_num - 1;
905:
915: p_object_type_code =>'WC',
916: p_employee_id => null, --l_wc_preparer_id,
917: p_sequence_num => l_sequence_num,
918: p_action_code => 'SUBMIT',
919: p_user_id => fnd_global.user_id ,
920: p_login_id =>fnd_global.login_id );
921:
922: END IF; --}
923:
916: p_employee_id => null, --l_wc_preparer_id,
917: p_sequence_num => l_sequence_num,
918: p_action_code => 'SUBMIT',
919: p_user_id => fnd_global.user_id ,
920: p_login_id =>fnd_global.login_id );
921:
922: END IF; --}
923:
924: /* Insert the null action code*/
944: p_request_id => 0,
945: p_program_application_id => 0,
946: p_program_id =>0 ,
947: p_program_date => sysdate ,
948: p_user_id => fnd_global.user_id ,
949: p_login_id => fnd_global.login_id); */
950:
951:
952:
945: p_program_application_id => 0,
946: p_program_id =>0 ,
947: p_program_date => sysdate ,
948: p_user_id => fnd_global.user_id ,
949: p_login_id => fnd_global.login_id); */
950:
951:
952:
953:
1515: p_object_type_code => Recinfo.object_type_code,
1516: p_employee_id => Recinfo.employee_id,
1517: p_action_code => 'FORWARD',
1518: p_note => NULL,
1519: p_user_id => fnd_global.user_id,
1520: p_login_id => fnd_global.login_id);
1521:
1522:
1523: End if;
1516: p_employee_id => Recinfo.employee_id,
1517: p_action_code => 'FORWARD',
1518: p_note => NULL,
1519: p_user_id => fnd_global.user_id,
1520: p_login_id => fnd_global.login_id);
1521:
1522:
1523: End if;
1524:
1550: p_request_id => Recinfo.request_id,
1551: p_program_application_id => Recinfo.program_application_id,
1552: p_program_id =>Recinfo.program_id ,
1553: p_program_date => Recinfo.program_date ,
1554: p_user_id => fnd_global.user_id ,
1555: p_login_id => fnd_global.login_id);
1556:
1557: End if;--}
1558:
1551: p_program_application_id => Recinfo.program_application_id,
1552: p_program_id =>Recinfo.program_id ,
1553: p_program_date => Recinfo.program_date ,
1554: p_user_id => fnd_global.user_id ,
1555: p_login_id => fnd_global.login_id);
1556:
1557: End if;--}
1558:
1559:
1945:
1946: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1947: itemkey => p_itemkey,
1948: aname => 'RESPONDER_USER_ID',
1949: avalue => fnd_global.USER_ID);
1950:
1951: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1952: itemkey => p_itemkey,
1953: aname => 'RESPONDER_RESP_ID',
1950:
1951: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1952: itemkey => p_itemkey,
1953: aname => 'RESPONDER_RESP_ID',
1954: avalue => fnd_global.RESP_ID);
1955:
1956: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1957: itemkey => p_itemkey,
1958: aname => 'RESPONDER_APPL_ID',
1955:
1956: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1957: itemkey => p_itemkey,
1958: aname => 'RESPONDER_APPL_ID',
1959: avalue => fnd_global.RESP_APPL_ID);
1960:
1961: OPEN c_group_id(p_itemtype, p_itemkey, 'WC_APPROVE');
1962:
1963: FETCH c_group_id INTO l_group_id;
2651: p_request_id => Recinfo.request_id,
2652: p_program_application_id => Recinfo.program_application_id,
2653: p_program_id =>Recinfo.program_id ,
2654: p_program_date => Recinfo.program_date ,
2655: p_user_id => fnd_global.user_id ,
2656: p_login_id => fnd_global.login_id);
2657:
2658:
2659: end if; --}
2652: p_program_application_id => Recinfo.program_application_id,
2653: p_program_id =>Recinfo.program_id ,
2654: p_program_date => Recinfo.program_date ,
2655: p_user_id => fnd_global.user_id ,
2656: p_login_id => fnd_global.login_id);
2657:
2658:
2659: end if; --}
2660:
2688: p_object_type_code => Recinfo.object_type_code,
2689: p_employee_id => p_more_info_id,
2690: p_action_code => 'NO ACTION',
2691: p_note => NULL,
2692: p_user_id => fnd_global.user_id,
2693: p_login_id => fnd_global.login_id);
2694:
2695:
2696:
2689: p_employee_id => p_more_info_id,
2690: p_action_code => 'NO ACTION',
2691: p_note => NULL,
2692: p_user_id => fnd_global.user_id,
2693: p_login_id => fnd_global.login_id);
2694:
2695:
2696:
2697: /*
2715: p_request_id => Recinfo.request_id,
2716: p_program_application_id => Recinfo.program_application_id,
2717: p_program_id =>Recinfo.program_id ,
2718: p_program_date => Recinfo.program_date ,
2719: p_user_id => fnd_global.user_id ,
2720: p_login_id => fnd_global.login_id);
2721:
2722:
2723: end if; --}
2716: p_program_application_id => Recinfo.program_application_id,
2717: p_program_id =>Recinfo.program_id ,
2718: p_program_date => Recinfo.program_date ,
2719: p_user_id => fnd_global.user_id ,
2720: p_login_id => fnd_global.login_id);
2721:
2722:
2723: end if; --}
2724:
2744: p_object_type_code => Recinfo.object_type_code,
2745: p_employee_id => Recinfo.employee_id,
2746: p_action_code => p_action_code,
2747: p_note =>substrb(p_comments,1,4000),
2748: p_user_id => fnd_global.user_id,
2749: p_login_id => fnd_global.login_id);
2750:
2751:
2752: END IF;
2745: p_employee_id => Recinfo.employee_id,
2746: p_action_code => p_action_code,
2747: p_note =>substrb(p_comments,1,4000),
2748: p_user_id => fnd_global.user_id,
2749: p_login_id => fnd_global.login_id);
2750:
2751:
2752: END IF;
2753:
2867:
2868: SELECT HR.EMPLOYEE_ID
2869: INTO l_employee_id
2870: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2871: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2872: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2873: IF (g_asn_debug = 'Y') THEN
2874: debug_log(FND_LOG.LEVEL_STATEMENT,
2875: l_api_name,'l_employee_id '
3203: p_object_type_code => Recinfo.object_type_code,
3204: p_employee_id => Recinfo.employee_id,
3205: p_action_code => l_action,
3206: p_note => wf_engine.context_user_comment,
3207: p_user_id => fnd_global.user_id,
3208: p_login_id => fnd_global.login_id);
3209:
3210:
3211: InsertPOActionHistory(
3204: p_employee_id => Recinfo.employee_id,
3205: p_action_code => l_action,
3206: p_note => wf_engine.context_user_comment,
3207: p_user_id => fnd_global.user_id,
3208: p_login_id => fnd_global.login_id);
3209:
3210:
3211: InsertPOActionHistory(
3212: p_object_id => Recinfo.object_id,
3222: p_request_id => Recinfo.request_id,
3223: p_program_application_id => Recinfo.program_application_id,
3224: p_program_id =>Recinfo.program_id ,
3225: p_program_date => Recinfo.program_date ,
3226: p_user_id => fnd_global.user_id ,
3227: p_login_id => fnd_global.login_id);
3228:
3229: -- end loop; --}
3230:
3223: p_program_application_id => Recinfo.program_application_id,
3224: p_program_id =>Recinfo.program_id ,
3225: p_program_date => Recinfo.program_date ,
3226: p_user_id => fnd_global.user_id ,
3227: p_login_id => fnd_global.login_id);
3228:
3229: -- end loop; --}
3230:
3231: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3906: 'VENDOR', --receipt_source_code,
3907: 'STD',
3908: 'NEW', -- transaction_type
3909: sysdate, --last_update_date,
3910: fnd_global.user_id , --last_updated_by
3911: sysdate, --creation_date
3912: fnd_global.login_id , --created_by
3913: l_vendor_id,
3914: l_vendor_site_id,
3908: 'NEW', -- transaction_type
3909: sysdate, --last_update_date,
3910: fnd_global.user_id , --last_updated_by
3911: sysdate, --creation_date
3912: fnd_global.login_id , --created_by
3913: l_vendor_id,
3914: l_vendor_site_id,
3915: l_ship_to_org_id,
3916: l_ship_to_location_id,
4224: (l_row_id,
4225: l_interface_id,--interface_id
4226: l_group_id, --group_id
4227: sysdate, --last_updated_date
4228: fnd_global.user_id, --last_updated_by,
4229: sysdate, --creation_date,
4230: fnd_global.login_id, --created_by,
4231: fnd_global.login_id, -- last_update_login,
4232: NULL, --request_id,
4226: l_group_id, --group_id
4227: sysdate, --last_updated_date
4228: fnd_global.user_id, --last_updated_by,
4229: sysdate, --creation_date,
4230: fnd_global.login_id, --created_by,
4231: fnd_global.login_id, -- last_update_login,
4232: NULL, --request_id,
4233: null, --program_application_id,
4234: null, --program_id,
4227: sysdate, --last_updated_date
4228: fnd_global.user_id, --last_updated_by,
4229: sysdate, --creation_date,
4230: fnd_global.login_id, --created_by,
4231: fnd_global.login_id, -- last_update_login,
4232: NULL, --request_id,
4233: null, --program_application_id,
4234: null, --program_id,
4235: null, --program_update_date,
4495:
4496: update rcv_shipment_headers
4497: set receipt_num= l_receipt_num,
4498: last_update_date = sysdate,
4499: last_updated_by = fnd_global.user_id,
4500: last_update_login = fnd_global.login_id
4501: where shipment_header_id = l_shipment_header_id;
4502: IF (g_asn_debug = 'Y') THEN
4503: debug_log(FND_LOG.LEVEL_STATEMENT,
4496: update rcv_shipment_headers
4497: set receipt_num= l_receipt_num,
4498: last_update_date = sysdate,
4499: last_updated_by = fnd_global.user_id,
4500: last_update_login = fnd_global.login_id
4501: where shipment_header_id = l_shipment_header_id;
4502: IF (g_asn_debug = 'Y') THEN
4503: debug_log(FND_LOG.LEVEL_STATEMENT,
4504: l_api_name,'Leave insert_into_rti ' );
4681:
4682: UPDATE rcv_shipment_headers
4683: SET WF_ITEM_TYPE = p_itemtype,
4684: WF_ITEM_KEY = p_itemkey,
4685: last_updated_by = fnd_global.user_id,
4686: last_update_login = fnd_global.login_id,
4687: last_update_date = sysdate
4688: WHERE shipment_header_id = p_shipment_header_id;
4689:
4682: UPDATE rcv_shipment_headers
4683: SET WF_ITEM_TYPE = p_itemtype,
4684: WF_ITEM_KEY = p_itemkey,
4685: last_updated_by = fnd_global.user_id,
4686: last_update_login = fnd_global.login_id,
4687: last_update_date = sysdate
4688: WHERE shipment_header_id = p_shipment_header_id;
4689:
4690: