DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PVT dependencies on FND_GLOBAL

Line 61: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

57: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Scoreresult_PVT';
58: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdrsb.pls';
59:
60: /***
61: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
62: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
63: ***/
64:
65: G_LIST_SOURCE_NAME VARCHAR2(30) := 'AMS_DM_SOURCE';

Line 62: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

58: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdrsb.pls';
59:
60: /***
61: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
62: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
63: ***/
64:
65: G_LIST_SOURCE_NAME VARCHAR2(30) := 'AMS_DM_SOURCE';
66:

Line 212: p_last_updated_by => FND_GLOBAL.USER_ID,

208: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Insert_Row)
209: AMS_DM_SCORE_RESULTS_PKG.Insert_Row(
210: px_score_result_id => l_score_result_id,
211: p_last_update_date => SYSDATE,
212: p_last_updated_by => FND_GLOBAL.USER_ID,
213: p_creation_date => SYSDATE,
214: p_created_by => FND_GLOBAL.USER_ID,
215: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
216: px_object_version_number => l_object_version_number,

Line 214: p_created_by => FND_GLOBAL.USER_ID,

210: px_score_result_id => l_score_result_id,
211: p_last_update_date => SYSDATE,
212: p_last_updated_by => FND_GLOBAL.USER_ID,
213: p_creation_date => SYSDATE,
214: p_created_by => FND_GLOBAL.USER_ID,
215: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
216: px_object_version_number => l_object_version_number,
217: p_score_id => p_scoreresult_rec.score_id,
218: p_decile => p_scoreresult_rec.decile,

Line 215: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

211: p_last_update_date => SYSDATE,
212: p_last_updated_by => FND_GLOBAL.USER_ID,
213: p_creation_date => SYSDATE,
214: p_created_by => FND_GLOBAL.USER_ID,
215: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
216: px_object_version_number => l_object_version_number,
217: p_score_id => p_scoreresult_rec.score_id,
218: p_decile => p_scoreresult_rec.decile,
219: p_num_records => p_scoreresult_rec.num_records,

Line 410: p_last_updated_by => FND_GLOBAL.USER_ID,

406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)
407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(
408: p_score_result_id => p_scoreresult_rec.score_result_id,
409: p_last_update_date => SYSDATE,
410: p_last_updated_by => FND_GLOBAL.USER_ID,
411: p_creation_date => SYSDATE,
412: p_created_by => l_ref_scoreresult_rec.created_by,
413: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
414: p_object_version_number => p_scoreresult_rec.object_version_number + 1,

Line 413: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

409: p_last_update_date => SYSDATE,
410: p_last_updated_by => FND_GLOBAL.USER_ID,
411: p_creation_date => SYSDATE,
412: p_created_by => l_ref_scoreresult_rec.created_by,
413: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
414: p_object_version_number => p_scoreresult_rec.object_version_number + 1,
415: p_score_id => p_scoreresult_rec.score_id,
416: p_decile => p_scoreresult_rec.decile,
417: p_num_records => p_scoreresult_rec.num_records,

Line 1259: FND_GLOBAL.user_id,

1255: random_result
1256: ) VALUES (
1257: ams_dm_score_pct_results_s.NEXTVAL,
1258: SYSDATE,
1259: FND_GLOBAL.user_id,
1260: SYSDATE,
1261: FND_GLOBAL.user_id,
1262: FND_GLOBAL.conc_login_id,
1263: 1,

Line 1261: FND_GLOBAL.user_id,

1257: ams_dm_score_pct_results_s.NEXTVAL,
1258: SYSDATE,
1259: FND_GLOBAL.user_id,
1260: SYSDATE,
1261: FND_GLOBAL.user_id,
1262: FND_GLOBAL.conc_login_id,
1263: 1,
1264: l_score_id,
1265: l_percentile,

Line 1262: FND_GLOBAL.conc_login_id,

1258: SYSDATE,
1259: FND_GLOBAL.user_id,
1260: SYSDATE,
1261: FND_GLOBAL.user_id,
1262: FND_GLOBAL.conc_login_id,
1263: 1,
1264: l_score_id,
1265: l_percentile,
1266: l_record_count,

Line 1345: FND_GLOBAL.user_id,

1341: random_result
1342: ) VALUES (
1343: ams_dm_score_pct_results_s.NEXTVAL,
1344: SYSDATE,
1345: FND_GLOBAL.user_id,
1346: SYSDATE,
1347: FND_GLOBAL.user_id,
1348: FND_GLOBAL.conc_login_id,
1349: 1,

Line 1347: FND_GLOBAL.user_id,

1343: ams_dm_score_pct_results_s.NEXTVAL,
1344: SYSDATE,
1345: FND_GLOBAL.user_id,
1346: SYSDATE,
1347: FND_GLOBAL.user_id,
1348: FND_GLOBAL.conc_login_id,
1349: 1,
1350: l_score_id,
1351: l_percentile_list(h),

Line 1348: FND_GLOBAL.conc_login_id,

1344: SYSDATE,
1345: FND_GLOBAL.user_id,
1346: SYSDATE,
1347: FND_GLOBAL.user_id,
1348: FND_GLOBAL.conc_login_id,
1349: 1,
1350: l_score_id,
1351: l_percentile_list(h),
1352: l_record_count_list(h),

Line 1376: FND_GLOBAL.user_id,

1372: random_result
1373: ) VALUES (
1374: ams_dm_score_pct_results_s.NEXTVAL,
1375: SYSDATE,
1376: FND_GLOBAL.user_id,
1377: SYSDATE,
1378: FND_GLOBAL.user_id,
1379: FND_GLOBAL.conc_login_id,
1380: 1,

Line 1378: FND_GLOBAL.user_id,

1374: ams_dm_score_pct_results_s.NEXTVAL,
1375: SYSDATE,
1376: FND_GLOBAL.user_id,
1377: SYSDATE,
1378: FND_GLOBAL.user_id,
1379: FND_GLOBAL.conc_login_id,
1380: 1,
1381: l_score_id,
1382: 0,

Line 1379: FND_GLOBAL.conc_login_id,

1375: SYSDATE,
1376: FND_GLOBAL.user_id,
1377: SYSDATE,
1378: FND_GLOBAL.user_id,
1379: FND_GLOBAL.conc_login_id,
1380: 1,
1381: l_score_id,
1382: 0,
1383: 0,

Line 1515: FND_GLOBAL.user_id,

1511: confidence
1512: ) VALUES (
1513: ams_dm_score_results_s.NEXTVAL,
1514: SYSDATE,
1515: FND_GLOBAL.user_id,
1516: SYSDATE,
1517: FND_GLOBAL.user_id,
1518: FND_GLOBAL.conc_login_id,
1519: 1,

Line 1517: FND_GLOBAL.user_id,

1513: ams_dm_score_results_s.NEXTVAL,
1514: SYSDATE,
1515: FND_GLOBAL.user_id,
1516: SYSDATE,
1517: FND_GLOBAL.user_id,
1518: FND_GLOBAL.conc_login_id,
1519: 1,
1520: p_score_id,
1521: l_result_rec.decile,

Line 1518: FND_GLOBAL.conc_login_id,

1514: SYSDATE,
1515: FND_GLOBAL.user_id,
1516: SYSDATE,
1517: FND_GLOBAL.user_id,
1518: FND_GLOBAL.conc_login_id,
1519: 1,
1520: p_score_id,
1521: l_result_rec.decile,
1522: l_result_rec.row_count,

Line 1786: EXECUTE Immediate l_insertSql USING FND_GLOBAL.USER_ID,FND_GLOBAL.USER_ID,FND_GLOBAL.CONC_LOGIN_ID,p_score_id, x_list_header_id ;

1782: IF (AMS_DEBUG_HIGH_ON) THEN
1783: AMS_Utility_PVT.debug_message ('SCORE LISTS SQL = ' || l_insertSql);
1784: END IF;
1785:
1786: EXECUTE Immediate l_insertSql USING FND_GLOBAL.USER_ID,FND_GLOBAL.USER_ID,FND_GLOBAL.CONC_LOGIN_ID,p_score_id, x_list_header_id ;
1787:
1788: END IF;
1789: EXCEPTION
1790: WHEN Fnd_Api.G_EXC_ERROR THEN