DBA Data[Home] [Help]

APPS.ASO_BI_APPR_FACT_PVT dependencies on FND_GLOBAL

Line 13: l_user_id := FND_GLOBAL.user_id;

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
16:
17: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_F FACT

Line 14: l_login_id := FND_GLOBAL.login_id;

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
16:
17: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_F FACT
18: (

Line 97: l_user_id := FND_GLOBAL.user_id;

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:
100: --Delete the modified approvals
101: DELETE FROM ASO_BI_APR_F FACT

Line 98: l_login_id := FND_GLOBAL.login_id;

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:
100: --Delete the modified approvals
101: DELETE FROM ASO_BI_APR_F FACT
102: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);

Line 197: l_user_id := FND_GLOBAL.user_id;

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:
200: --insert statement
201: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_RUL_F FACT

Line 198: l_login_id := FND_GLOBAL.login_id;

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:
200: --insert statement
201: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_RUL_F FACT
202: (

Line 267: l_user_id := FND_GLOBAL.user_id;

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:
270: --Delete the modified approvals
271: DELETE FROM ASO_BI_APR_RUL_F FACT

Line 268: l_login_id := FND_GLOBAL.login_id;

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:
270: --Delete the modified approvals
271: DELETE FROM ASO_BI_APR_RUL_F FACT
272: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);