APPS.BOMDELEX dependencies on BOM_COMMON_DEFINITIONS

Line 69: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;

65: UPDATE BOM_EXPLOSIONS
66: SET REQUEST_ID = NULL
67: WHERE TOP_BILL_SEQUENCE_ID = top_bill_seq_id
68: AND EXPLOSION_TYPE = expl_type
69: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
70:
71: Commit ;
72:
73: RETCODE := 0 ;

Line 82: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;

78: UPDATE BOM_EXPLOSIONS
79: SET REQUEST_ID = NULL
80: WHERE TOP_BILL_SEQUENCE_ID = top_bill_seq_id
81: AND EXPLOSION_TYPE = expl_type
82: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
83: commit;
84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Either Top assembly Item Id or Explosion type is not specified') ;
85: RETCODE := 2;
86: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

Line 93: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;

89: UPDATE BOM_EXPLOSIONS
90: SET REQUEST_ID = NULL
91: WHERE TOP_BILL_SEQUENCE_ID = top_bill_seq_id
92: AND EXPLOSION_TYPE = expl_type
93: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
94: commit;
95:
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'The concurrent request did not complete
97: successfully');

Line 125: AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;

121: SELECT Request_id
122: FROM Bom_explosions
123: WHERE top_bill_sequence_id = top_bill_id
124: AND explosion_type = expl_type
125: AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;
126:
127: X_Req_Id Number := 0;
128: Req_Id Number := 0;
129: Bill_Id Number := 0;

Line 174: and SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;

170: Update bom_explosions
171: set REQUEST_ID = X_req_id
172: where top_bill_sequence_id = C1.top_bill_sequence_id
173: and explosion_type = C1.explosion_type
174: and SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
175: Commit;
176: Return_Status := 'S';
177: Else
178: Return_Status := 'E';