DBA Data[Home] [Help]

APPS.AMW_CONTROLS_PAGE_PKG dependencies on FND_GLOBAL

Line 5: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1: PACKAGE BODY AMW_CONTROLS_PAGE_PKG as
2: /* $Header: amwcnpgb.pls 120.1 2005/11/10 05:09:10 appldev noship $ */
3:
4: --NPANANDI 11.19.2004 BEGIN
5: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_CONTROLS_PAGE_PKG';
8: --NPANANDI 11.19.2004 END
9:

Line 6: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

2: /* $Header: amwcnpgb.pls 120.1 2005/11/10 05:09:10 appldev noship $ */
3:
4: --NPANANDI 11.19.2004 BEGIN
5: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
6: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_CONTROLS_PAGE_PKG';
8: --NPANANDI 11.19.2004 END
9:
10: FUNCTION OBJECTIVE_PRESENT (P_CONTROL_REV_ID IN NUMBER,

Line 412: l_created_by := FND_GLOBAL.USER_ID;

408:
409: if (p_select_flag = 'Y') then
410:
411: l_creation_date := SYSDATE;
412: l_created_by := FND_GLOBAL.USER_ID;
413: l_last_update_date := SYSDATE;
414: l_last_updated_by := FND_GLOBAL.USER_ID;
415: l_last_update_login := FND_GLOBAL.USER_ID;
416:

Line 414: l_last_updated_by := FND_GLOBAL.USER_ID;

410:
411: l_creation_date := SYSDATE;
412: l_created_by := FND_GLOBAL.USER_ID;
413: l_last_update_date := SYSDATE;
414: l_last_updated_by := FND_GLOBAL.USER_ID;
415: l_last_update_login := FND_GLOBAL.USER_ID;
416:
417: select amw_control_objectives_s.nextval into l_control_objective_id from dual;
418:

Line 415: l_last_update_login := FND_GLOBAL.USER_ID;

411: l_creation_date := SYSDATE;
412: l_created_by := FND_GLOBAL.USER_ID;
413: l_last_update_date := SYSDATE;
414: l_last_updated_by := FND_GLOBAL.USER_ID;
415: l_last_update_login := FND_GLOBAL.USER_ID;
416:
417: select amw_control_objectives_s.nextval into l_control_objective_id from dual;
418:
419: insert into amw_control_objectives (control_objective_id,

Line 506: l_created_by := FND_GLOBAL.USER_ID;

502:
503: if (p_select_flag = 'Y') then
504:
505: l_creation_date := SYSDATE;
506: l_created_by := FND_GLOBAL.USER_ID;
507: l_last_update_date := SYSDATE;
508: l_last_updated_by := FND_GLOBAL.USER_ID;
509: l_last_update_login := FND_GLOBAL.USER_ID;
510:

Line 508: l_last_updated_by := FND_GLOBAL.USER_ID;

504:
505: l_creation_date := SYSDATE;
506: l_created_by := FND_GLOBAL.USER_ID;
507: l_last_update_date := SYSDATE;
508: l_last_updated_by := FND_GLOBAL.USER_ID;
509: l_last_update_login := FND_GLOBAL.USER_ID;
510:
511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;
512:

Line 509: l_last_update_login := FND_GLOBAL.USER_ID;

505: l_creation_date := SYSDATE;
506: l_created_by := FND_GLOBAL.USER_ID;
507: l_last_update_date := SYSDATE;
508: l_last_updated_by := FND_GLOBAL.USER_ID;
509: l_last_update_login := FND_GLOBAL.USER_ID;
510:
511: select amw_control_assertions_s.nextval into l_control_assertion_id from dual;
512:
513: insert into amw_control_assertions (control_assertion_id,

Line 601: l_created_by := FND_GLOBAL.USER_ID;

597:
598: if (p_select_flag = 'Y') then
599:
600: l_creation_date := SYSDATE;
601: l_created_by := FND_GLOBAL.USER_ID;
602: l_last_update_date := SYSDATE;
603: l_last_updated_by := FND_GLOBAL.USER_ID;
604: l_last_update_login := FND_GLOBAL.USER_ID;
605:

Line 603: l_last_updated_by := FND_GLOBAL.USER_ID;

599:
600: l_creation_date := SYSDATE;
601: l_created_by := FND_GLOBAL.USER_ID;
602: l_last_update_date := SYSDATE;
603: l_last_updated_by := FND_GLOBAL.USER_ID;
604: l_last_update_login := FND_GLOBAL.USER_ID;
605:
606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
607:

Line 604: l_last_update_login := FND_GLOBAL.USER_ID;

600: l_creation_date := SYSDATE;
601: l_created_by := FND_GLOBAL.USER_ID;
602: l_last_update_date := SYSDATE;
603: l_last_updated_by := FND_GLOBAL.USER_ID;
604: l_last_update_login := FND_GLOBAL.USER_ID;
605:
606: select amw_assessment_components_s.nextval into l_assessment_component_id from dual;
607:
608: insert into amw_assessment_components (assessment_component_id,

Line 921: IF FND_GLOBAL.User_Id IS NULL THEN

917: IF FND_API.to_Boolean( p_init_msg_list ) THEN
918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: IF FND_GLOBAL.User_Id IS NULL THEN
922: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:

Line 1139: ,FND_GLOBAL.USER_ID

1135: AMW_CONTROL_PURPOSES_S.NEXTVAL
1136: ,p_control_rev_id
1137: ,p_PURPOSE_code
1138: ,SYSDATE
1139: ,FND_GLOBAL.USER_ID
1140: ,SYSDATE
1141: ,FND_GLOBAL.USER_ID
1142: ,FND_GLOBAL.LOGIN_ID);
1143: end if;

Line 1141: ,FND_GLOBAL.USER_ID

1137: ,p_PURPOSE_code
1138: ,SYSDATE
1139: ,FND_GLOBAL.USER_ID
1140: ,SYSDATE
1141: ,FND_GLOBAL.USER_ID
1142: ,FND_GLOBAL.LOGIN_ID);
1143: end if;
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_ERROR THEN

Line 1142: ,FND_GLOBAL.LOGIN_ID);

1138: ,SYSDATE
1139: ,FND_GLOBAL.USER_ID
1140: ,SYSDATE
1141: ,FND_GLOBAL.USER_ID
1142: ,FND_GLOBAL.LOGIN_ID);
1143: end if;
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_ERROR THEN
1146: IF p_commit = FND_API.G_TRUE THEN