APPS.ENG_LAUNCH_ECO_OI_PK dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 1418: mtl_system_items_interface_s.nextval,

1414: ERROR_MESSAGE,
1415: TRANSACTION_ID)
1416: VALUES
1417: (p_error_tbl(i).organization_id,
1418: mtl_system_items_interface_s.nextval,
1419: sysdate,
1420: FND_GLOBAL.USER_ID,
1421: sysdate,
1422: FND_GLOBAL.USER_ID,

Line 3140: SET transaction_id = mtl_system_items_interface_s.nextval,

3136:
3137: --dbms_output.put_line('Set transaction ids');
3138: stmt_num := 10.1;
3139: UPDATE eng_eng_changes_interface
3140: SET transaction_id = mtl_system_items_interface_s.nextval,
3141: transaction_type = UPPER(transaction_type)
3142: WHERE process_flag = 1
3143: AND (transaction_id is NULL
3144: OR transaction_id = FND_API.G_MISS_NUM)

Line 3151: SET transaction_id = mtl_system_items_interface_s.nextval,

3147: (p_all_org = 2 AND organization_id = p_org_id));
3148:
3149: stmt_num := 10.2;
3150: UPDATE eng_eco_revisions_interface
3151: SET transaction_id = mtl_system_items_interface_s.nextval,
3152: transaction_type = UPPER(transaction_type)
3153: WHERE process_flag = 1
3154: AND (transaction_id is NULL
3155: OR transaction_id = FND_API.G_MISS_NUM)

Line 3162: SET transaction_id = mtl_system_items_interface_s.nextval,

3158: (p_all_org = 2 AND organization_id = p_org_id));
3159:
3160: stmt_num := 10.3;
3161: UPDATE eng_revised_items_interface
3162: SET transaction_id = mtl_system_items_interface_s.nextval,
3163: transaction_type = UPPER(transaction_type)
3164: WHERE process_flag = 1
3165: AND (transaction_id is NULL
3166: OR transaction_id = FND_API.G_MISS_NUM)

Line 3173: SET transaction_id = mtl_system_items_interface_s.nextval,

3169: (p_all_org = 2 AND organization_id = p_org_id));
3170:
3171: stmt_num := 10.4;
3172: UPDATE bom_inventory_comps_interface
3173: SET transaction_id = mtl_system_items_interface_s.nextval,
3174: transaction_type = UPPER(transaction_type)
3175: WHERE process_flag = 1
3176: AND (transaction_id is NULL
3177: OR transaction_id = FND_API.G_MISS_NUM)

Line 3185: SET transaction_id = mtl_system_items_interface_s.nextval,

3181: (p_all_org = 2 AND organization_id = p_org_id));
3182:
3183: stmt_num := 10.5;
3184: UPDATE bom_sub_comps_interface
3185: SET transaction_id = mtl_system_items_interface_s.nextval,
3186: transaction_type = UPPER(transaction_type)
3187: WHERE process_flag = 1
3188: AND (transaction_id is NULL
3189: OR transaction_id = FND_API.G_MISS_NUM)

Line 3197: SET transaction_id = mtl_system_items_interface_s.nextval,

3193: (p_all_org = 2 AND organization_id = p_org_id));
3194:
3195: stmt_num := 10.6;
3196: UPDATE bom_ref_desgs_interface
3197: SET transaction_id = mtl_system_items_interface_s.nextval,
3198: transaction_type = UPPER(transaction_type)
3199: WHERE process_flag = 1
3200: AND (transaction_id is NULL
3201: OR transaction_id = FND_API.G_MISS_NUM)

Line 3209: SET transaction_id = mtl_system_items_interface_s.nextval,

3205: (p_all_org = 2 AND organization_id = p_org_id));
3206:
3207: stmt_num := 10.7;
3208: UPDATE bom_op_sequences_interface
3209: SET transaction_id = mtl_system_items_interface_s.nextval,
3210: transaction_type = UPPER(transaction_type)
3211: WHERE process_flag = 1
3212: AND (transaction_id is NULL
3213: OR transaction_id = FND_API.G_MISS_NUM)

Line 3220: SET transaction_id = mtl_system_items_interface_s.nextval,

3216: (p_all_org = 2 AND organization_id = p_org_id));
3217:
3218: stmt_num := 10.8;
3219: UPDATE bom_op_resources_interface
3220: SET transaction_id = mtl_system_items_interface_s.nextval,
3221: transaction_type = UPPER(transaction_type)
3222: WHERE process_flag = 1
3223: AND (transaction_id is NULL
3224: OR transaction_id = FND_API.G_MISS_NUM)

Line 3231: SET transaction_id = mtl_system_items_interface_s.nextval,

3227: (p_all_org = 2 AND organization_id = p_org_id));
3228:
3229: stmt_num := 10.9;
3230: UPDATE bom_sub_op_resources_interface
3231: SET transaction_id = mtl_system_items_interface_s.nextval,
3232: transaction_type = UPPER(transaction_type)
3233: WHERE process_flag = 1
3234: AND (transaction_id is NULL
3235: OR transaction_id = FND_API.G_MISS_NUM)