588: , quantity
589: , unit_number )
590: SELECT l_id
591: , sysdate
592: , fnd_global.user_id
593: , fnd_global.user_id
594: , sysdate
595: , fnd_global.login_id
596: , p_target_deliverable_number
589: , unit_number )
590: SELECT l_id
591: , sysdate
592: , fnd_global.user_id
593: , fnd_global.user_id
594: , sysdate
595: , fnd_global.login_id
596: , p_target_deliverable_number
597: , 'PA'
591: , sysdate
592: , fnd_global.user_id
593: , fnd_global.user_id
594: , sysdate
595: , fnd_global.login_id
596: , p_target_deliverable_number
597: , 'PA'
598: , p_target_project_id
599: , null
629: , project_id
630: , delivery_date)
631: SELECT l_id
632: , sysdate
633: , fnd_global.user_id
634: , fnd_global.user_id
635: , sysdate
636: , fnd_global.login_id
637: , p_target_deliverable_number
630: , delivery_date)
631: SELECT l_id
632: , sysdate
633: , fnd_global.user_id
634: , fnd_global.user_id
635: , sysdate
636: , fnd_global.login_id
637: , p_target_deliverable_number
638: , 'PA'
632: , sysdate
633: , fnd_global.user_id
634: , fnd_global.user_id
635: , sysdate
636: , fnd_global.login_id
637: , p_target_deliverable_number
638: , 'PA'
639: , p_target_project_id
640: , null
660: , comments )
661: SELECT l_id
662: , l.language_code
663: , sysdate
664: , fnd_global.user_id
665: , sysdate
666: , fnd_global.user_id
667: , fnd_global.login_id
668: , oke_utils.get_userenv_lang
662: , l.language_code
663: , sysdate
664: , fnd_global.user_id
665: , sysdate
666: , fnd_global.user_id
667: , fnd_global.login_id
668: , oke_utils.get_userenv_lang
669: , L_Deliverable_Description
670: , L_Deliverable_Comments
663: , sysdate
664: , fnd_global.user_id
665: , sysdate
666: , fnd_global.user_id
667: , fnd_global.login_id
668: , oke_utils.get_userenv_lang
669: , L_Deliverable_Description
670: , L_Deliverable_Comments
671: FROM fnd_languages l
809: , quantity
810: , uom_code)
811: SELECT oke_k_deliverables_s.nextval
812: , sysdate
813: , fnd_global.user_id
814: , sysdate
815: , fnd_global.user_id
816: , fnd_global.login_id
817: , action_type
811: SELECT oke_k_deliverables_s.nextval
812: , sysdate
813: , fnd_global.user_id
814: , sysdate
815: , fnd_global.user_id
816: , fnd_global.login_id
817: , action_type
818: , p_target_action_name
819: , p_target_action_id
812: , sysdate
813: , fnd_global.user_id
814: , sysdate
815: , fnd_global.user_id
816: , fnd_global.login_id
817: , action_type
818: , p_target_action_name
819: , p_target_action_id
820: , l_deliverable_id
1641: , EXPECTED_DATE
1642: , destination_type_code
1643: ) VALUES ( L_ID
1644: , SYSDATE
1645: , FND_GLOBAL.USER_ID
1646: , SYSDATE
1647: , FND_GLOBAL.USER_ID
1648: , FND_GLOBAL.LOGIN_ID
1649: , P_ACTION_TYPE
1643: ) VALUES ( L_ID
1644: , SYSDATE
1645: , FND_GLOBAL.USER_ID
1646: , SYSDATE
1647: , FND_GLOBAL.USER_ID
1648: , FND_GLOBAL.LOGIN_ID
1649: , P_ACTION_TYPE
1650: , P_SOURCE_ACTION_NAME
1651: , L_DELIVERABLE_ID
1644: , SYSDATE
1645: , FND_GLOBAL.USER_ID
1646: , SYSDATE
1647: , FND_GLOBAL.USER_ID
1648: , FND_GLOBAL.LOGIN_ID
1649: , P_ACTION_TYPE
1650: , P_SOURCE_ACTION_NAME
1651: , L_DELIVERABLE_ID
1652: , P_SOURCE_ACTION_ID