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 168: l_CREATED_BY := FND_GLOBAL.user_id;

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

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

1009: l_error_text VARCHAR2(128) DEFAULT NULL;
1010: l_batch_id_error EXCEPTION;
1011: l_reference_num_error EXCEPTION;
1012: l_retcode NUMBER DEFAULT 0;
1013: l_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;
1014: l_user_name fnd_user.user_name%TYPE := 'OTM';
1015: l_sysdate DATE := trunc(SYSDATE);
1016: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1017: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );

Line 2083: l_CREATED_BY := FND_GLOBAL.user_id;

2079:
2080: SELECT hxt_seqno.nextval
2081: INTO l_EXCEP_seqno
2082: FROM dual;
2083: l_CREATED_BY := FND_GLOBAL.user_id;
2084: l_person_id := GetPersonID(p_TIM_ID); -- ER230
2085: l_payroll_id := GetPayrollID(p_PTP_ID); -- ER230
2086:
2087: insert into hxt_errors_f(

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

2192: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)
2193: AND NVL(end_date_active, SYSDATE)
2194: AND LANGUAGE = userenv('LANG')
2195: AND VIEW_APPLICATION_ID = 3
2196: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,VIEW_APPLICATION_ID)
2197: AND enabled_flag = 'Y'
2198: AND lookup_type = p_lookup_type;
2199:
2200: BEGIN