APPS.ENG_LAUNCH_ECO_OI_PK dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 1422: mtl_system_items_interface_s.nextval,

1418: ERROR_MESSAGE,
1419: TRANSACTION_ID)
1420: VALUES
1421: (p_error_tbl(i).organization_id,
1422: mtl_system_items_interface_s.nextval,
1423: sysdate,
1424: FND_GLOBAL.USER_ID,
1425: sysdate,
1426: FND_GLOBAL.USER_ID,

Line 3146: SET transaction_id = mtl_system_items_interface_s.nextval,

3142:
3143: --dbms_output.put_line('Set transaction ids');
3144: stmt_num := 10.1;
3145: UPDATE eng_eng_changes_interface
3146: SET transaction_id = mtl_system_items_interface_s.nextval,
3147: transaction_type = UPPER(transaction_type)
3148: WHERE process_flag = 1
3149: AND (transaction_id is NULL
3150: OR transaction_id = FND_API.G_MISS_NUM)

Line 3157: SET transaction_id = mtl_system_items_interface_s.nextval,

3153: (p_all_org = 2 AND organization_id = p_org_id));
3154:
3155: stmt_num := 10.2;
3156: UPDATE eng_eco_revisions_interface
3157: SET transaction_id = mtl_system_items_interface_s.nextval,
3158: transaction_type = UPPER(transaction_type)
3159: WHERE process_flag = 1
3160: AND (transaction_id is NULL
3161: OR transaction_id = FND_API.G_MISS_NUM)

Line 3168: SET transaction_id = mtl_system_items_interface_s.nextval,

3164: (p_all_org = 2 AND organization_id = p_org_id));
3165:
3166: stmt_num := 10.3;
3167: UPDATE eng_revised_items_interface
3168: SET transaction_id = mtl_system_items_interface_s.nextval,
3169: transaction_type = UPPER(transaction_type)
3170: WHERE process_flag = 1
3171: AND (transaction_id is NULL
3172: OR transaction_id = FND_API.G_MISS_NUM)

Line 3179: SET transaction_id = mtl_system_items_interface_s.nextval,

3175: (p_all_org = 2 AND organization_id = p_org_id));
3176:
3177: stmt_num := 10.4;
3178: UPDATE bom_inventory_comps_interface
3179: SET transaction_id = mtl_system_items_interface_s.nextval,
3180: transaction_type = UPPER(transaction_type)
3181: WHERE process_flag = 1
3182: AND (transaction_id is NULL
3183: OR transaction_id = FND_API.G_MISS_NUM)

Line 3191: SET transaction_id = mtl_system_items_interface_s.nextval,

3187: (p_all_org = 2 AND organization_id = p_org_id));
3188:
3189: stmt_num := 10.5;
3190: UPDATE bom_sub_comps_interface
3191: SET transaction_id = mtl_system_items_interface_s.nextval,
3192: transaction_type = UPPER(transaction_type)
3193: WHERE process_flag = 1
3194: AND (transaction_id is NULL
3195: OR transaction_id = FND_API.G_MISS_NUM)

Line 3203: SET transaction_id = mtl_system_items_interface_s.nextval,

3199: (p_all_org = 2 AND organization_id = p_org_id));
3200:
3201: stmt_num := 10.6;
3202: UPDATE bom_ref_desgs_interface
3203: SET transaction_id = mtl_system_items_interface_s.nextval,
3204: transaction_type = UPPER(transaction_type)
3205: WHERE process_flag = 1
3206: AND (transaction_id is NULL
3207: OR transaction_id = FND_API.G_MISS_NUM)

Line 3215: SET transaction_id = mtl_system_items_interface_s.nextval,

3211: (p_all_org = 2 AND organization_id = p_org_id));
3212:
3213: stmt_num := 10.7;
3214: UPDATE bom_op_sequences_interface
3215: SET transaction_id = mtl_system_items_interface_s.nextval,
3216: transaction_type = UPPER(transaction_type)
3217: WHERE process_flag = 1
3218: AND (transaction_id is NULL
3219: OR transaction_id = FND_API.G_MISS_NUM)

Line 3226: SET transaction_id = mtl_system_items_interface_s.nextval,

3222: (p_all_org = 2 AND organization_id = p_org_id));
3223:
3224: stmt_num := 10.8;
3225: UPDATE bom_op_resources_interface
3226: SET transaction_id = mtl_system_items_interface_s.nextval,
3227: transaction_type = UPPER(transaction_type)
3228: WHERE process_flag = 1
3229: AND (transaction_id is NULL
3230: OR transaction_id = FND_API.G_MISS_NUM)

Line 3237: SET transaction_id = mtl_system_items_interface_s.nextval,

3233: (p_all_org = 2 AND organization_id = p_org_id));
3234:
3235: stmt_num := 10.9;
3236: UPDATE bom_sub_op_resources_interface
3237: SET transaction_id = mtl_system_items_interface_s.nextval,
3238: transaction_type = UPPER(transaction_type)
3239: WHERE process_flag = 1
3240: AND (transaction_id is NULL
3241: OR transaction_id = FND_API.G_MISS_NUM)