41: open c_check_item;
42: fetch c_check_item into x_deliverable_id;
43: if (c_check_item%NOTFOUND) then
44:
45: l_user_id := fnd_global.user_id;
46:
47: select OKE_K_DELIVERABLES_S.NEXTVAL
48: into X_DELIVERABLE_ID
49: from dual;
539: , ship_from_org_id
540: ) VALUES (
541: oke_k_deliverables_s.NEXTVAL
542: , SYSDATE
543: , FND_GLOBAL.USER_ID
544: , SYSDATE
545: , FND_GLOBAL.USER_ID
546: , FND_GLOBAL.LOGIN_ID
547: , 'WSH'
541: oke_k_deliverables_s.NEXTVAL
542: , SYSDATE
543: , FND_GLOBAL.USER_ID
544: , SYSDATE
545: , FND_GLOBAL.USER_ID
546: , FND_GLOBAL.LOGIN_ID
547: , 'WSH'
548: , x_ship_name
549: , X_DELIVERABLE_ID
542: , SYSDATE
543: , FND_GLOBAL.USER_ID
544: , SYSDATE
545: , FND_GLOBAL.USER_ID
546: , FND_GLOBAL.LOGIN_ID
547: , 'WSH'
548: , x_ship_name
549: , X_DELIVERABLE_ID
550: , x_ship_id
577: , destination_type_code
578: ) VALUES (
579: oke_k_deliverables_s.NEXTVAL
580: , SYSDATE
581: , FND_GLOBAL.USER_ID
582: , SYSDATE
583: , FND_GLOBAL.USER_ID
584: , FND_GLOBAL.LOGIN_ID
585: , 'REQ'
579: oke_k_deliverables_s.NEXTVAL
580: , SYSDATE
581: , FND_GLOBAL.USER_ID
582: , SYSDATE
583: , FND_GLOBAL.USER_ID
584: , FND_GLOBAL.LOGIN_ID
585: , 'REQ'
586: , x_proc_name
587: , X_DELIVERABLE_ID
580: , SYSDATE
581: , FND_GLOBAL.USER_ID
582: , SYSDATE
583: , FND_GLOBAL.USER_ID
584: , FND_GLOBAL.LOGIN_ID
585: , 'REQ'
586: , x_proc_name
587: , X_DELIVERABLE_ID
588: , x_proc_id