DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on FND_GLOBAL

Line 70: l_CREATED_BY := FND_GLOBAL.user_id;

66: --
67: SELECT hxt_seqno.nextval
68: INTO l_EXCEP_seqno
69: FROM dual;
70: l_CREATED_BY := FND_GLOBAL.user_id;
71:
72: l_person_id := GetPersonID(p_TIM_ID);
73: l_payroll_id := GetPayrollID(p_PTP_ID);
74:

Line 170: l_CREATED_BY := FND_GLOBAL.user_id;

166: --
167: SELECT hxt_seqno.nextval
168: INTO l_EXCEP_seqno
169: FROM dual;
170: l_CREATED_BY := FND_GLOBAL.user_id;
171:
172: l_person_id := GetPersonID(p_TIM_ID);
173: l_payroll_id := GetPayrollID(p_PTP_ID);
174:

Line 1032: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;

1028: l_error_text VARCHAR2(128) DEFAULT NULL;
1029: l_batch_id_error EXCEPTION;
1030: l_reference_num_error EXCEPTION;
1031: l_retcode NUMBER DEFAULT 0;
1032: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;
1033: l_user_name fnd_user.user_name%TYPE := 'OTM';
1034: l_sysdate DATE := trunc(SYSDATE);
1035: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1036: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );

Line 2163: l_CREATED_BY := FND_GLOBAL.user_id;

2159:
2160: SELECT hxt_seqno.nextval
2161: INTO l_EXCEP_seqno
2162: FROM dual;
2163: l_CREATED_BY := FND_GLOBAL.user_id;
2164: l_person_id := GetPersonID(p_TIM_ID); -- ER230
2165: l_payroll_id := GetPayrollID(p_PTP_ID); -- ER230
2166:
2167:

Line 2278: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,VIEW_APPLICATION_ID)

2274: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)
2275: AND NVL(end_date_active, SYSDATE)
2276: AND LANGUAGE = userenv('LANG')
2277: AND VIEW_APPLICATION_ID = 3
2278: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,VIEW_APPLICATION_ID)
2279: AND enabled_flag = 'Y'
2280: AND lookup_type = p_lookup_type;
2281:
2282: BEGIN