407: AND qpc.enabled_flag = 1
408: ORDER BY qpc.prompt_sequence;
409:
410: BEGIN
411: if (icx_sec.validatesession) then
412:
413: htp.p('');
414:
415: htp.p('
449: -- The below is useful for collection import and QLTCORE.pld
450: -- uses these values to display contact info etc in CIMDF
451: -- Bso has done those changes
452: -- source line id has the fnd_user userid got thro ICX call
453: qri_source_line_id := icx_sec.getID(icx_sec.PV_USER_ID);
454:
455: if (txn_num = 100) THEN
456: qri_source_code := 'QA_SS_OSP';
457: elsif (txn_num = 110) THEN
459: end if;
460:
461:
462:
463: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
464: if (l_date_format is NULL) then
465: l_date_format := 'DD/MON/RRRR';
466: end if;
467:
1033: ORDER BY qpc.prompt_sequence;
1034: -- changed above cursor qpc.prompt, qpc.default_value
1035: -- to fix bug 1276799
1036: BEGIN
1037: if (icx_sec.validatesession) then
1038:
1039: fnd_message.clear;
1040:
1041: Default_In_Values(Ctx, Txn_Num, PK1, PK2, PK3, PK4,
1048: -- Also above function will alter some global package variables
1049: -- Keep in mind it will set global variables starting with G_etc.
1050:
1051:
1052: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1053: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
1054:
1055: Name := owa_util.get_cgi_env('SCRIPT_NAME');
1056:
1049: -- Keep in mind it will set global variables starting with G_etc.
1050:
1051:
1052: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1053: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);
1054:
1055: Name := owa_util.get_cgi_env('SCRIPT_NAME');
1056:
1057: select qp.name into plan_name_i
1080: icx_plug_utilities.plugbanner(plan_name_i);
1081: */
1082: -- htp.p('Org id is ' || fnd_profile.value('ORG_ID') );
1083: -- htp.p('User id is ' || fnd_profile.value('USER_ID') );
1084: -- htp.p('pvwebuserid: ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID));
1085:
1086: --hidden_elems; -- CALL TO HIDDEN_ELEMS to set hidden fields
1087: htp.p('