DBA Data[Home] [Help]

APPS.JL_JLZZRCVI_XMLP_PKG dependencies on FND_PROFILE

Line 558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');

554: L_PROG_APPL_ID NUMBER;
555: L_CONC_PROG_ID NUMBER;
556: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;
557: BEGIN
558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');
561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');
562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');

Line 559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');

555: L_CONC_PROG_ID NUMBER;
556: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;
557: BEGIN
558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');
561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');
562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
563: IF P_COUNTRY_CODE = 'CL' THEN

Line 560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');

556: L_TRX_REC RA_CUSTOMER_TRX%ROWTYPE;
557: BEGIN
558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');
561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');
562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
563: IF P_COUNTRY_CODE = 'CL' THEN
564: SELECT

Line 561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');

557: BEGIN
558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');
561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');
562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
563: IF P_COUNTRY_CODE = 'CL' THEN
564: SELECT
565: CUST_TRX_TYPE_ID

Line 562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');

558: L_USER_ID := FND_PROFILE.VALUE('USER_ID');
559: L_CONC_LOGIN_ID := FND_PROFILE.VALUE('CONC_LOGIN_ID');
560: L_LOGIN_ID := FND_PROFILE.VALUE('LOGIN_ID');
561: L_PROG_APPL_ID := FND_PROFILE.VALUE('PROG_APPL_ID');
562: L_CONC_PROG_ID := FND_PROFILE.VALUE('CONC_PROGRAM_ID');
563: IF P_COUNTRY_CODE = 'CL' THEN
564: SELECT
565: CUST_TRX_TYPE_ID
566: INTO L_VOID_TRX_TYPE_ID