eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_ETC_CONC_PROG dependencies on FND_LOOKUP_VALUES

Line 389: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

385:
386: l_Err_Msg VARCHAR2(1000) := NULL;
387: l_Err_Code VARCHAR(1) := 'N';
388:
389: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
390: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
391: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
392: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
393:

Line 390: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

386: l_Err_Msg VARCHAR2(1000) := NULL;
387: l_Err_Code VARCHAR(1) := 'N';
388:
389: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
390: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
391: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
392: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
393:
394: BEGIN

Line 391: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

387: l_Err_Code VARCHAR(1) := 'N';
388:
389: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
390: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
391: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
392: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
393:
394: BEGIN
395: --log for debug

Line 392: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

388:
389: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
390: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
391: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
392: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
393:
394: BEGIN
395: --log for debug
396: IF (l_Proc_Level >= l_Dbg_Level) THEN

Line 716: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

712:
713: l_Chr_Result VARCHAR2(10);
714: l_Fn_Result VARCHAR2(10);
715:
716: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
717: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
718: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
719: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
720: l_Err_Msg VARCHAR2(1000) := NULL;

Line 717: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

713: l_Chr_Result VARCHAR2(10);
714: l_Fn_Result VARCHAR2(10);
715:
716: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
717: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
718: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
719: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
720: l_Err_Msg VARCHAR2(1000) := NULL;
721:

Line 718: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

714: l_Fn_Result VARCHAR2(10);
715:
716: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
717: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
718: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
719: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
720: l_Err_Msg VARCHAR2(1000) := NULL;
721:
722: --

Line 719: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

715:
716: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
717: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
718: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
719: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
720: l_Err_Msg VARCHAR2(1000) := NULL;
721:
722: --
723: l_program_name varchar(100) := '';

Line 861: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

857:
858: l_Chr_Result VARCHAR2(10);
859: l_Fn_Result VARCHAR2(10);
860:
861: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
862: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
863: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
864: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
865: l_Err_Msg VARCHAR2(1000) := NULL;

Line 862: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

858: l_Chr_Result VARCHAR2(10);
859: l_Fn_Result VARCHAR2(10);
860:
861: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
862: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
863: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
864: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
865: l_Err_Msg VARCHAR2(1000) := NULL;
866:

Line 863: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

859: l_Fn_Result VARCHAR2(10);
860:
861: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
862: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
863: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
864: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
865: l_Err_Msg VARCHAR2(1000) := NULL;
866:
867: BEGIN

Line 864: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

860:
861: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
862: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
863: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
864: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
865: l_Err_Msg VARCHAR2(1000) := NULL;
866:
867: BEGIN
868: --Call Concurrent of 'Ent_GSSM_Export'

Line 981: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

977:
978: l_Chr_Result VARCHAR2(10);
979: l_Fn_Result VARCHAR2(10);
980:
981: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
982: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
983: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
984: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
985: l_Err_Msg VARCHAR2(1000) := NULL;

Line 982: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

978: l_Chr_Result VARCHAR2(10);
979: l_Fn_Result VARCHAR2(10);
980:
981: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
982: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
983: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
984: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
985: l_Err_Msg VARCHAR2(1000) := NULL;
986:

Line 983: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

979: l_Fn_Result VARCHAR2(10);
980:
981: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
982: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
983: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
984: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
985: l_Err_Msg VARCHAR2(1000) := NULL;
986:
987: BEGIN

Line 984: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

980:
981: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
982: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
983: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
984: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
985: l_Err_Msg VARCHAR2(1000) := NULL;
986:
987: BEGIN
988: --Call Concurrent of 'Pub_GSSM_Export'

Line 1095: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

1091:
1092: l_Chr_Result VARCHAR2(10);
1093: l_Fn_Result VARCHAR2(10);
1094:
1095: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1096: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1097: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1098: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1099: l_Err_Msg VARCHAR2(1000) := NULL;

Line 1096: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

1092: l_Chr_Result VARCHAR2(10);
1093: l_Fn_Result VARCHAR2(10);
1094:
1095: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1096: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1097: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1098: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1099: l_Err_Msg VARCHAR2(1000) := NULL;
1100:

Line 1097: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

1093: l_Fn_Result VARCHAR2(10);
1094:
1095: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1096: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1097: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1098: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1099: l_Err_Msg VARCHAR2(1000) := NULL;
1100:
1101: BEGIN

Line 1098: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

1094:
1095: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1096: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1097: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1098: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1099: l_Err_Msg VARCHAR2(1000) := NULL;
1100:
1101: BEGIN
1102:

Line 1270: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;

1266:
1267: l_Chr_Result VARCHAR2(10);
1268: l_Fn_Result VARCHAR2(10);
1269:
1270: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1271: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1272: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1273: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1274: l_Err_Msg VARCHAR2(1000) := NULL;

Line 1271: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;

1267: l_Chr_Result VARCHAR2(10);
1268: l_Fn_Result VARCHAR2(10);
1269:
1270: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1271: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1272: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1273: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1274: l_Err_Msg VARCHAR2(1000) := NULL;
1275:

Line 1272: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;

1268: l_Fn_Result VARCHAR2(10);
1269:
1270: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1271: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1272: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1273: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1274: l_Err_Msg VARCHAR2(1000) := NULL;
1275:
1276: BEGIN

Line 1273: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;

1269:
1270: l_Req_Phase Fnd_Lookup_Values.Lookup_Code%TYPE;
1271: l_Req_Status Fnd_Lookup_Values.Lookup_Code%TYPE;
1272: l_User_Phase Fnd_Lookup_Values.Meaning%TYPE;
1273: l_User_Status Fnd_Lookup_Values.Meaning%TYPE;
1274: l_Err_Msg VARCHAR2(1000) := NULL;
1275:
1276: BEGIN
1277: l_Reqid := Fnd_Request.Submit_Request(Application => 'JA',