74:
75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
76:
77: g_atp_flag varchar2(1) := 'N' ;
78: gUserId number := nvl(Fnd_Global.USER_ID, -1);
79: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
80:
81: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
82:
75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
76:
77: g_atp_flag varchar2(1) := 'N' ;
78: gUserId number := nvl(Fnd_Global.USER_ID, -1);
79: gLoginId number := nvl(Fnd_Global.LOGIN_ID, -1);
80:
81: TYPE ATTRIB_NAME_TAB_TYPE is table of mtl_item_attributes.attribute_name%type index by binary_integer ;
82:
83: TYPE CONTROL_LEVEL_TAB_TYPE is table of mtl_item_attributes.control_level%type index by binary_integer ;
2833: X_to_pk2_value => v_get_org_id.cfg_item_id,
2834: X_to_pk3_value => NULL,
2835: X_to_pk4_value => NULL,
2836: X_to_pk5_value => NULL,
2837: X_created_by => fnd_global.USER_ID,
2838: X_last_update_login => fnd_global.USER_ID,
2839: X_program_application_id => fnd_global.PROG_APPL_ID,
2840: X_program_id => fnd_global.CONC_REQUEST_ID,
2841: X_request_id => fnd_global.USER_ID,
2834: X_to_pk3_value => NULL,
2835: X_to_pk4_value => NULL,
2836: X_to_pk5_value => NULL,
2837: X_created_by => fnd_global.USER_ID,
2838: X_last_update_login => fnd_global.USER_ID,
2839: X_program_application_id => fnd_global.PROG_APPL_ID,
2840: X_program_id => fnd_global.CONC_REQUEST_ID,
2841: X_request_id => fnd_global.USER_ID,
2842: X_automatically_added_flag => NULL
2835: X_to_pk4_value => NULL,
2836: X_to_pk5_value => NULL,
2837: X_created_by => fnd_global.USER_ID,
2838: X_last_update_login => fnd_global.USER_ID,
2839: X_program_application_id => fnd_global.PROG_APPL_ID,
2840: X_program_id => fnd_global.CONC_REQUEST_ID,
2841: X_request_id => fnd_global.USER_ID,
2842: X_automatically_added_flag => NULL
2843: );
2836: X_to_pk5_value => NULL,
2837: X_created_by => fnd_global.USER_ID,
2838: X_last_update_login => fnd_global.USER_ID,
2839: X_program_application_id => fnd_global.PROG_APPL_ID,
2840: X_program_id => fnd_global.CONC_REQUEST_ID,
2841: X_request_id => fnd_global.USER_ID,
2842: X_automatically_added_flag => NULL
2843: );
2844:
2837: X_created_by => fnd_global.USER_ID,
2838: X_last_update_login => fnd_global.USER_ID,
2839: X_program_application_id => fnd_global.PROG_APPL_ID,
2840: X_program_id => fnd_global.CONC_REQUEST_ID,
2841: X_request_id => fnd_global.USER_ID,
2842: X_automatically_added_flag => NULL
2843: );
2844:
2845: WriteToLog('Done copy attachment for org id::'|| v_get_org_id.src_org_id,5);