DBA Data[Home] [Help]

APPS.IEX_SCORE_PVT dependencies on FND_GLOBAL

Line 413: IF FND_GLOBAL.User_Id IS NULL

409: -- ******************************************************************
410: -- Validate Environment
411: -- ******************************************************************
412: /*
413: IF FND_GLOBAL.User_Id IS NULL
414: THEN
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417: AS_UTILITY_PVT.Set_Message(

Line 497: , p_last_updated_by => FND_GLOBAL.USER_ID

493: , p_campaign_sched_id => l_score_rec.campaign_sched_id
494: , p_jtf_object_code => l_score_rec.jtf_object_code
495: , p_concurrent_prog_name => l_score_rec.concurrent_prog_name
496: , p_last_update_date => sysdate
497: , p_last_updated_by => FND_GLOBAL.USER_ID
498: , p_creation_date => sysdate
499: , p_created_by => FND_GLOBAL.USER_ID
500: , p_last_update_login => FND_GLOBAL.USER_ID
501: , p_request_id => l_score_rec.request_id

Line 499: , p_created_by => FND_GLOBAL.USER_ID

495: , p_concurrent_prog_name => l_score_rec.concurrent_prog_name
496: , p_last_update_date => sysdate
497: , p_last_updated_by => FND_GLOBAL.USER_ID
498: , p_creation_date => sysdate
499: , p_created_by => FND_GLOBAL.USER_ID
500: , p_last_update_login => FND_GLOBAL.USER_ID
501: , p_request_id => l_score_rec.request_id
502: , p_program_application_id => l_score_rec.program_application_id
503: , p_program_id => l_score_rec.program_id

Line 500: , p_last_update_login => FND_GLOBAL.USER_ID

496: , p_last_update_date => sysdate
497: , p_last_updated_by => FND_GLOBAL.USER_ID
498: , p_creation_date => sysdate
499: , p_created_by => FND_GLOBAL.USER_ID
500: , p_last_update_login => FND_GLOBAL.USER_ID
501: , p_request_id => l_score_rec.request_id
502: , p_program_application_id => l_score_rec.program_application_id
503: , p_program_id => l_score_rec.program_id
504: , p_program_update_date => l_score_rec.program_update_date

Line 793: , p_last_updated_by => FND_GLOBAL.USER_ID

789: , p_campaign_sched_id => l_score_rec.campaign_sched_id
790: , p_jtf_object_code => l_score_rec.jtf_object_code
791: , p_concurrent_prog_name => l_score_rec.concurrent_prog_name
792: , p_last_update_date => sysdate
793: , p_last_updated_by => FND_GLOBAL.USER_ID
794: , p_creation_date => l_score_rec.creation_date
795: , p_created_by => l_score_rec.created_by
796: , p_last_update_login => FND_GLOBAL.USER_ID
797: , p_request_id => l_score_rec.request_id

Line 796: , p_last_update_login => FND_GLOBAL.USER_ID

792: , p_last_update_date => sysdate
793: , p_last_updated_by => FND_GLOBAL.USER_ID
794: , p_creation_date => l_score_rec.creation_date
795: , p_created_by => l_score_rec.created_by
796: , p_last_update_login => FND_GLOBAL.USER_ID
797: , p_request_id => l_score_rec.request_id
798: , p_program_application_id => l_score_rec.program_application_id
799: , p_program_id => l_score_rec.program_id
800: , p_program_update_date => l_score_rec.program_update_date

Line 1183: , p_last_updated_by => FND_GLOBAL.USER_ID

1179: IEX_SCORE_COMPONENTS_PKG.insert_row(
1180: x_rowid => l_rowid
1181: , p_score_component_id => x_score_comp_id
1182: , p_last_update_date => sysdate
1183: , p_last_updated_by => FND_GLOBAL.USER_ID
1184: , p_creation_date => sysdate
1185: , p_created_by => FND_GLOBAL.USER_ID
1186: , p_last_update_login => FND_GLOBAL.USER_ID
1187: , p_score_comp_weight => l_score_comp_rec.score_comp_weight

Line 1185: , p_created_by => FND_GLOBAL.USER_ID

1181: , p_score_component_id => x_score_comp_id
1182: , p_last_update_date => sysdate
1183: , p_last_updated_by => FND_GLOBAL.USER_ID
1184: , p_creation_date => sysdate
1185: , p_created_by => FND_GLOBAL.USER_ID
1186: , p_last_update_login => FND_GLOBAL.USER_ID
1187: , p_score_comp_weight => l_score_comp_rec.score_comp_weight
1188: , p_score_id => l_score_comp_rec.score_id
1189: , p_enabled_flag => l_score_comp_rec.enabled_flag

Line 1186: , p_last_update_login => FND_GLOBAL.USER_ID

1182: , p_last_update_date => sysdate
1183: , p_last_updated_by => FND_GLOBAL.USER_ID
1184: , p_creation_date => sysdate
1185: , p_created_by => FND_GLOBAL.USER_ID
1186: , p_last_update_login => FND_GLOBAL.USER_ID
1187: , p_score_comp_weight => l_score_comp_rec.score_comp_weight
1188: , p_score_id => l_score_comp_rec.score_id
1189: , p_enabled_flag => l_score_comp_rec.enabled_flag
1190: , P_SCORE_COMP_TYPE_ID => l_score_comp_rec.SCORE_COMP_TYPE_ID);

Line 1423: , p_last_updated_by => FND_GLOBAL.USER_ID

1419: , p_score_id => l_score_comp_rec.score_id
1420: , p_enabled_flag => l_score_comp_rec.enabled_flag
1421: , P_SCORE_COMP_TYPE_ID => l_score_comp_rec.SCORE_COMP_TYPE_ID
1422: , p_last_update_date => sysdate
1423: , p_last_updated_by => FND_GLOBAL.USER_ID
1424: , p_creation_date => l_score_comp_rec.creation_date
1425: , p_created_by => l_score_Comp_rec.created_by
1426: , p_last_update_login => FND_GLOBAL.USER_ID);
1427:

Line 1426: , p_last_update_login => FND_GLOBAL.USER_ID);

1422: , p_last_update_date => sysdate
1423: , p_last_updated_by => FND_GLOBAL.USER_ID
1424: , p_creation_date => l_score_comp_rec.creation_date
1425: , p_created_by => l_score_Comp_rec.created_by
1426: , p_last_update_login => FND_GLOBAL.USER_ID);
1427:
1428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1740: , p_last_updated_by => FND_GLOBAL.USER_ID

1736: , p_active_flag => l_score_comp_type_rec.active_flag
1737: , P_description => l_score_comp_type_rec.Description
1738: , P_jtf_object_code => l_score_comp_type_rec.jtf_object_code
1739: , p_last_update_date => sysdate
1740: , p_last_updated_by => FND_GLOBAL.USER_ID
1741: , p_creation_date => sysdate
1742: , p_created_by => FND_GLOBAL.USER_ID
1743: , p_last_update_login => FND_GLOBAL.USER_ID
1744: , p_function_flag => l_score_comp_type_rec.function_flag

Line 1742: , p_created_by => FND_GLOBAL.USER_ID

1738: , P_jtf_object_code => l_score_comp_type_rec.jtf_object_code
1739: , p_last_update_date => sysdate
1740: , p_last_updated_by => FND_GLOBAL.USER_ID
1741: , p_creation_date => sysdate
1742: , p_created_by => FND_GLOBAL.USER_ID
1743: , p_last_update_login => FND_GLOBAL.USER_ID
1744: , p_function_flag => l_score_comp_type_rec.function_flag
1745: , p_metric_flag => l_score_comp_type_rec.metric_flag
1746: , p_display_order => l_score_comp_type_rec.display_order);

Line 1743: , p_last_update_login => FND_GLOBAL.USER_ID

1739: , p_last_update_date => sysdate
1740: , p_last_updated_by => FND_GLOBAL.USER_ID
1741: , p_creation_date => sysdate
1742: , p_created_by => FND_GLOBAL.USER_ID
1743: , p_last_update_login => FND_GLOBAL.USER_ID
1744: , p_function_flag => l_score_comp_type_rec.function_flag
1745: , p_metric_flag => l_score_comp_type_rec.metric_flag
1746: , p_display_order => l_score_comp_type_rec.display_order);
1747:

Line 2018: , p_last_updated_by => FND_GLOBAL.USER_ID

2014: , p_display_order => l_score_comp_type_rec.display_order
2015: , P_object_version_number => l_score_comp_type_rec.object_version_number
2016: , p_description => l_score_comp_type_rec.description
2017: , p_last_update_date => sysdate
2018: , p_last_updated_by => FND_GLOBAL.USER_ID
2019: , p_last_update_login => FND_GLOBAL.USER_ID);
2020:
2021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2022: RAISE FND_API.G_EXC_ERROR;

Line 2019: , p_last_update_login => FND_GLOBAL.USER_ID);

2015: , P_object_version_number => l_score_comp_type_rec.object_version_number
2016: , p_description => l_score_comp_type_rec.description
2017: , p_last_update_date => sysdate
2018: , p_last_updated_by => FND_GLOBAL.USER_ID
2019: , p_last_update_login => FND_GLOBAL.USER_ID);
2020:
2021: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2022: RAISE FND_API.G_EXC_ERROR;
2023: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2312: , p_last_updated_by => FND_GLOBAL.USER_ID

2308: , p_score_component_id => l_score_comp_det_rec.score_component_id
2309: , p_object_version_number => l_score_comp_det_rec.object_version_number
2310: , p_program_id => l_score_comp_det_rec.program_id
2311: , p_last_update_date => sysdate
2312: , p_last_updated_by => FND_GLOBAL.USER_ID
2313: , p_creation_date => sysdate
2314: , p_created_by => FND_GLOBAL.USER_ID
2315: , p_last_update_login => FND_GLOBAL.USER_ID);
2316:

Line 2314: , p_created_by => FND_GLOBAL.USER_ID

2310: , p_program_id => l_score_comp_det_rec.program_id
2311: , p_last_update_date => sysdate
2312: , p_last_updated_by => FND_GLOBAL.USER_ID
2313: , p_creation_date => sysdate
2314: , p_created_by => FND_GLOBAL.USER_ID
2315: , p_last_update_login => FND_GLOBAL.USER_ID);
2316:
2317:
2318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2315: , p_last_update_login => FND_GLOBAL.USER_ID);

2311: , p_last_update_date => sysdate
2312: , p_last_updated_by => FND_GLOBAL.USER_ID
2313: , p_creation_date => sysdate
2314: , p_created_by => FND_GLOBAL.USER_ID
2315: , p_last_update_login => FND_GLOBAL.USER_ID);
2316:
2317:
2318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2319: RAISE FND_API.G_EXC_ERROR;

Line 2529: , p_last_updated_by => FND_GLOBAL.USER_ID

2525: IEX_SCORE_COMP_DET_PKG.update_row(
2526: x_rowid => l_rowid
2527: , p_score_comp_det_id => l_score_comp_det_rec.score_comp_det_id
2528: , p_last_update_date => sysdate
2529: , p_last_updated_by => FND_GLOBAL.USER_ID
2530: , p_creation_date => l_score_comp_det_rec.CREATION_DATE
2531: , p_created_by => l_score_comp_det_rec.CREATED_BY
2532: , p_last_update_login => FND_GLOBAL.USER_ID
2533: , p_range_low => l_score_comp_det_rec.range_low

Line 2532: , p_last_update_login => FND_GLOBAL.USER_ID

2528: , p_last_update_date => sysdate
2529: , p_last_updated_by => FND_GLOBAL.USER_ID
2530: , p_creation_date => l_score_comp_det_rec.CREATION_DATE
2531: , p_created_by => l_score_comp_det_rec.CREATED_BY
2532: , p_last_update_login => FND_GLOBAL.USER_ID
2533: , p_range_low => l_score_comp_det_rec.range_low
2534: , p_range_high => l_score_comp_det_rec.range_high
2535: , p_value => l_score_comp_det_rec.value
2536: , p_new_value => l_score_comp_det_rec.new_value

Line 3461: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

3457: P_SCORE_HISTORY_ID => l_score_history_id,
3458: P_OBJECT_VERSION_NUMBER => 1,
3459: P_PROGRAM_ID => 1,
3460: P_LAST_UPDATE_DATE => sysdate,
3461: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3462: P_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID,
3463: P_CREATION_DATE => sysdate,
3464: P_CREATED_BY => FND_GLOBAL.USER_ID,
3465: P_SCORE_VALUE => l_running_score,

Line 3462: P_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID,

3458: P_OBJECT_VERSION_NUMBER => 1,
3459: P_PROGRAM_ID => 1,
3460: P_LAST_UPDATE_DATE => sysdate,
3461: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3462: P_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID,
3463: P_CREATION_DATE => sysdate,
3464: P_CREATED_BY => FND_GLOBAL.USER_ID,
3465: P_SCORE_VALUE => l_running_score,
3466: P_SCORE_ID => l_score_id,

Line 3464: P_CREATED_BY => FND_GLOBAL.USER_ID,

3460: P_LAST_UPDATE_DATE => sysdate,
3461: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
3462: P_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID,
3463: P_CREATION_DATE => sysdate,
3464: P_CREATED_BY => FND_GLOBAL.USER_ID,
3465: P_SCORE_VALUE => l_running_score,
3466: P_SCORE_ID => l_score_id,
3467: P_PARTY_ID => l_party_id);
3468: */

Line 3495: ,FND_GLOBAL.USER_ID

3491: values(IEX_SCORE_HISTORIES_S.nextval
3492: ,1
3493: ,1
3494: ,sysdate
3495: ,FND_GLOBAL.USER_ID
3496: ,FND_GLOBAL.USER_ID
3497: ,sysdate
3498: ,FND_GLOBAL.USER_ID
3499: ,l_score_tbl(n)

Line 3496: ,FND_GLOBAL.USER_ID

3492: ,1
3493: ,1
3494: ,sysdate
3495: ,FND_GLOBAL.USER_ID
3496: ,FND_GLOBAL.USER_ID
3497: ,sysdate
3498: ,FND_GLOBAL.USER_ID
3499: ,l_score_tbl(n)
3500: ,l_score_id

Line 3498: ,FND_GLOBAL.USER_ID

3494: ,sysdate
3495: ,FND_GLOBAL.USER_ID
3496: ,FND_GLOBAL.USER_ID
3497: ,sysdate
3498: ,FND_GLOBAL.USER_ID
3499: ,l_score_tbl(n)
3500: ,l_score_id
3501: ,l_party_tbl(n));
3502: