APPS.PQH_PQHUSNRW_XMLP_PKG dependencies on FND_GLOBAL

Line 40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

36: AND P_END_DATE
37: AND PAP.PERSON_ID = P_PERSON_ID
38: AND PE.BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_ID;
39: BEGIN
40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
41: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
42: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
43: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

Line 78: ,fnd_global.local_chr(10)

74: INTO
75: L_REVIEW_DATE;
76: CLOSE EMP_REVU_CUR;
77: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
78: ,fnd_global.local_chr(10)
79: ,'');
80: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
81: ,fnd_global.local_chr(10)
82: ,'');

Line 81: ,fnd_global.local_chr(10)

77: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
78: ,fnd_global.local_chr(10)
79: ,'');
80: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
81: ,fnd_global.local_chr(10)
82: ,'');
83: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
84: ,'REVIEW_DATE'
85: ,L_REVIEW_DATE);

Line 87: ,fnd_global.local_chr(38)

83: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
84: ,'REVIEW_DATE'
85: ,L_REVIEW_DATE);
86: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
87: ,fnd_global.local_chr(38)
88: ,'');
89: P_START_DATE_T := to_char(P_START_DATE,'DD-MON-YYYY');
90: P_END_DATE_T := to_char(P_END_DATE,'DD-MON-YYYY');
91: