APPS.ASO_BI_APPR_FACT_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 11: BIS_COLLECTION_UTILITIES.Debug('Start populating the Approvals fact Table');

7: l_user_id number;
8: l_login_id number;
9: Begin
10:
11: BIS_COLLECTION_UTILITIES.Debug('Start populating the Approvals fact Table');
12:
13: l_user_id := FND_GLOBAL.user_id;
14: l_login_id := FND_GLOBAL.login_id;
15: --insert statement

Line 81: BIS_COLLECTION_UTILITIES.Debug('Done populating the Approvals fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

77: QOT.Quote_expiration_date,
78: APR.Object_approval_id,APR.Approval_instance_id,APR.Approval_status,
79: TRUNC(APR.Start_date),APR.End_date,TRUNC(NVL(APR.end_date, QOT.Quote_expiration_date));
80:
81: BIS_COLLECTION_UTILITIES.Debug('Done populating the Approvals fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
82:
83: COMMIT;
84:
85: end Appr_Init_Load;

Line 95: BIS_COLLECTION_UTILITIES.Debug('Start populating the Approvals fact Table');

91: l_user_id number;
92: l_login_id number;
93: Begin
94:
95: BIS_COLLECTION_UTILITIES.Debug('Start populating the Approvals fact Table');
96:
97: l_user_id := FND_GLOBAL.user_id;
98: l_login_id := FND_GLOBAL.login_id;
99:

Line 178: BIS_COLLECTION_UTILITIES.Debug('Done populating the Approvals fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

174: where a.quote_version < (select MAX(quote_version)
175: from ASO_BI_APR_F b
176: where a.quote_number = b.quote_number);
177:
178: BIS_COLLECTION_UTILITIES.Debug('Done populating the Approvals fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
179:
180: COMMIT;
181:
182:

Line 195: BIS_COLLECTION_UTILITIES.Debug('Start populating the Rules fact Table');

191: l_user_id number;
192: l_login_id number;
193: Begin
194:
195: BIS_COLLECTION_UTILITIES.Debug('Start populating the Rules fact Table');
196:
197: l_user_id := FND_GLOBAL.user_id;
198: l_login_id := FND_GLOBAL.login_id;
199:

Line 250: BIS_COLLECTION_UTILITIES.Debug('Done populating the Rules fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

246: WHERE
247: APRF.object_approval_id = RUL.object_approval_id;
248:
249:
250: BIS_COLLECTION_UTILITIES.Debug('Done populating the Rules fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
251:
252: COMMIT;
253:
254:

Line 265: BIS_COLLECTION_UTILITIES.Debug('Start populating the Rules fact Table');

261: l_user_id number;
262: l_login_id number;
263: Begin
264:
265: BIS_COLLECTION_UTILITIES.Debug('Start populating the Rules fact Table');
266:
267: l_user_id := FND_GLOBAL.user_id;
268: l_login_id := FND_GLOBAL.login_id;
269:

Line 326: BIS_COLLECTION_UTILITIES.Debug('Done populating the Rules fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

322: APRF.Object_approval_id = RUL.Object_approval_id
323: AND QID.Quote_header_id = APRF.Quote_header_id;
324:
325:
326: BIS_COLLECTION_UTILITIES.Debug('Done populating the Rules fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
327:
328: COMMIT;
329:
330: END Rul_Incremental_load;