DBA Data[Home] [Help]

APPS.QA_SS_CORE dependencies on ICX_SEC

Line 411: if (icx_sec.validatesession) then

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('');

Line 453: qri_source_line_id := icx_sec.getID(icx_sec.PV_USER_ID);

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

Line 463: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

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:

Line 1037: if (icx_sec.validatesession) then

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,

Line 1052: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

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:

Line 1053: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID);

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

Line 1084: -- htp.p('pvwebuserid: ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID));

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('

');
1088: htp.formHidden('x_txn_num', txn_num);

Line 1446: if (icx_sec.validatesession) then

1442: FROM QA_PLANS
1443: WHERE plan_id = plan_id_i ;
1444:
1445: BEGIN
1446: if (icx_sec.validatesession) then
1447: l_language_code := icx_sec.getid(icx_sec.PV_LANGUAGE_CODE);
1448:
1449: OPEN plan_name_cur;
1450: FETCH plan_name_cur INTO l_plan_name;

Line 1447: l_language_code := icx_sec.getid(icx_sec.PV_LANGUAGE_CODE);

1443: WHERE plan_id = plan_id_i ;
1444:
1445: BEGIN
1446: if (icx_sec.validatesession) then
1447: l_language_code := icx_sec.getid(icx_sec.PV_LANGUAGE_CODE);
1448:
1449: OPEN plan_name_cur;
1450: FETCH plan_name_cur INTO l_plan_name;
1451: CLOSE plan_name_cur;

Line 1597: if (icx_sec.validatesession) then

1593: msg varchar2(2000);
1594: l_profile_val NUMBER;
1595:
1596: BEGIN
1597: if (icx_sec.validatesession) then
1598: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1599: if (l_language_code is Null) then
1600: l_language_code := 'US';
1601: end if;

Line 1598: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1594: l_profile_val NUMBER;
1595:
1596: BEGIN
1597: if (icx_sec.validatesession) then
1598: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1599: if (l_language_code is Null) then
1600: l_language_code := 'US';
1601: end if;
1602:

Line 1792: if (icx_sec.validatesession) then

1788: ORDER BY qpc.prompt_sequence;
1789:
1790: BEGIN
1791: -- htp.p('vqr procedure entered');
1792: if (icx_sec.validatesession) then
1793:
1794: fnd_message.clear;
1795: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1796:

Line 1795: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1791: -- htp.p('vqr procedure entered');
1792: if (icx_sec.validatesession) then
1793:
1794: fnd_message.clear;
1795: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1796:
1797:
1798: -- htp.p('after lang code: ' || l_language_code);
1799: -- htp.p('ss_where='||ss_where_clause); htp.nl;

Line 3334: -- sanity check: dont think icx_sec.validatesession is needed here

3330: Dummy_tab qa_ss_const.num_table;
3331:
3332:
3333: BEGIN
3334: -- sanity check: dont think icx_sec.validatesession is needed here
3335: -- becos this function is part of wip's osp view
3336: -- but mentioning this comment as a check
3337:
3338:

Line 3381: if (icx_sec.validatesession) then

3377: IS
3378: Pid_table qa_ss_const.num_table;
3379: ret_val boolean;
3380: BEGIN
3381: if (icx_sec.validatesession) then
3382:
3383: NULL;
3384:
3385: ret_val := Evaluate_Triggers(Ctx, Txn_Number, organization_id,

Line 3643: if (icx_sec.validatesession) then

3639:
3640: plan_rec plan_cur%ROWTYPE;
3641:
3642: BEGIN
3643: if (icx_sec.validatesession) then
3644:
3645: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3646:
3647: -- Added new function security July 30, 1999

Line 3645: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

3641:
3642: BEGIN
3643: if (icx_sec.validatesession) then
3644:
3645: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3646:
3647: -- Added new function security July 30, 1999
3648: show_eqr := FND_FUNCTION.TEST('ICX_QA_ENTER_QUALITY');
3649:

Line 3836: l_language_code := ICX_Sec.GetId(ICX_SEC.PV_LANGUAGE_CODE);

3832: toolbar_heading VARCHAR2(500);
3833: l_language_code VARCHAR2(30);
3834: BEGIN
3835:
3836: l_language_code := ICX_Sec.GetId(ICX_SEC.PV_LANGUAGE_CODE);
3837:
3838: IF (txn_num=100) then
3839: url_str :='qa_ss_osp.osp_plans';
3840: ELSIF (txn_num=110) then

Line 3952: if (icx_sec.validateSession) THEN

3948: FROM QA_PLANS
3949: WHERE plan_id = plan_id_i ;
3950:
3951: BEGIN
3952: if (icx_sec.validateSession) THEN
3953:
3954: l_language_code := ICX_Sec.GetId(icx_sec.PV_LANGUAGE_CODE);
3955:
3956: OPEN plan_name_cur;

Line 3954: l_language_code := ICX_Sec.GetId(icx_sec.PV_LANGUAGE_CODE);

3950:
3951: BEGIN
3952: if (icx_sec.validateSession) THEN
3953:
3954: l_language_code := ICX_Sec.GetId(icx_sec.PV_LANGUAGE_CODE);
3955:
3956: OPEN plan_name_cur;
3957: FETCH plan_name_cur INTO l_plan_name;
3958: CLOSE plan_name_cur;