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.QA_SS_CORE dependencies on QA_PLANS

Line 968: procedure draw_table(plan_id_i IN qa_plans.plan_id%TYPE DEFAULT NULL,

964: END enter_results;
965: ------------------------------------------------------------------------
966:
967:
968: procedure draw_table(plan_id_i IN qa_plans.plan_id%TYPE DEFAULT NULL,
969: txn_num IN NUMBER DEFAULT NULL,
970: orgz_id IN NUMBER DEFAULT NULL,
971: pk1 IN VARCHAR2 DEFAULT NULL,
972: pk2 IN VARCHAR2 DEFAULT NULL,

Line 992: plan_name_i qa_plans.name%TYPE := NULL;

988: charid_array qa_ss_const.num_table;
989: names_array qa_ss_const.var30_table;
990:
991: no_of_cols NUMBER := 0;
992: plan_name_i qa_plans.name%TYPE := NULL;
993: l_language_code varchar2(30);
994: it_name VARCHAR2(20);
995: de_name VARCHAR2(20); -- dependent element name
996: Name VARCHAR2(2000);

Line 1058: from qa_plans qp

1054:
1055: Name := owa_util.get_cgi_env('SCRIPT_NAME');
1056:
1057: select qp.name into plan_name_i
1058: from qa_plans qp
1059: where qp.plan_id = plan_id_i;
1060:
1061: -- htp.p('Debug: Job = ' || job_i);
1062:

Line 1419: procedure draw_frames(plan_id_i IN qa_plans.plan_id%TYPE DEFAULT NULL,

1415: END is_lov_needed;
1416:
1417: ------------------------------------------------------------------------------------------
1418:
1419: procedure draw_frames(plan_id_i IN qa_plans.plan_id%TYPE DEFAULT NULL,
1420: txn_num IN NUMBER DEFAULT NULL,
1421: orgz_id IN NUMBER DEFAULT NULL,
1422: pk1 IN VARCHAR2 DEFAULT NULL,
1423: pk2 IN VARCHAR2 DEFAULT NULL,

Line 1442: FROM QA_PLANS

1438: l_language_code VARCHAR2(30);
1439:
1440: CURSOR plan_name_cur IS
1441: SELECT name
1442: FROM QA_PLANS
1443: WHERE plan_id = plan_id_i ;
1444:
1445: BEGIN
1446: if (icx_sec.validatesession) then

Line 1750: procedure VQR(plan_id_i IN qa_plans.plan_id%TYPE,

1746: END Default_In_Values;
1747:
1748: ------------------------------------------------------------------------------------
1749:
1750: procedure VQR(plan_id_i IN qa_plans.plan_id%TYPE,
1751: start_row IN NUMBER DEFAULT 1,
1752: end_row IN NUMBER DEFAULT 20,
1753: ss_where_clause in varchar2 default null)
1754:

Line 1771: plan_name_i qa_plans.name%TYPE := NULL;

1767: charname qa_ss_const.var30_table;
1768:
1769: charid qa_ss_const.num_table;
1770: sql_st VARCHAR2(32000) := NULL;
1771: plan_name_i qa_plans.name%TYPE := NULL;
1772:
1773: row_color VARCHAR2(10) := 'BLUE';
1774:
1775: l_query_size NUMBER := 20;

Line 1806: from qa_plans qp

1802: end if;
1803: num_of_col := 0;
1804:
1805: select qp.name into plan_name_i
1806: from qa_plans qp
1807: where qp.plan_id = plan_id_i;
1808:
1809: vname := 'Q_' || replace(substr(plan_name_i,1,25),' ','_') || '_V';
1810: vname := UPPER(vname);

Line 3432: qa_plans_val_v qp,

3428: qpct.Low_Value,
3429: qpct.High_Value
3430: FROM qa_plan_collection_triggers qpct,
3431: qa_plan_transactions qpt,
3432: qa_plans_val_v qp,
3433: qa_chars qc,
3434: qa_txn_collection_triggers qtct
3435: WHERE qpt.Plan_ID = qp.Plan_ID
3436: AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID

Line 3634: from qa_plans qp, fnd_common_lookups fcl

3630:
3631: CURSOR plan_cur (X_Pid NUMBER)
3632: IS
3633: Select qp.name, qp.description, fcl.meaning
3634: from qa_plans qp, fnd_common_lookups fcl
3635: where qp.plan_id = X_Pid
3636: and qp.plan_type_code = fcl.lookup_code
3637: and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'
3638: Order By qp.name;

Line 3744: attachurl := 'qa_ss_attachment.qa_plans_view_attachment?plan_id=' || pid_i;

3740:
3741: viewurl := 'qa_ss_core.VQR_Frames?plan_id_i=' || pid_i
3742: || '&'
3743: || 'ss_where_clause=';
3744: attachurl := 'qa_ss_attachment.qa_plans_view_attachment?plan_id=' || pid_i;
3745: -- viewurl := 'qa_results_interface_pkg.Proc1?x=100';
3746:
3747: atchmt := qa_ss_attachment.qa_plans_attachment_status(pid_i);
3748:

Line 3747: atchmt := qa_ss_attachment.qa_plans_attachment_status(pid_i);

3743: || 'ss_where_clause=';
3744: attachurl := 'qa_ss_attachment.qa_plans_view_attachment?plan_id=' || pid_i;
3745: -- viewurl := 'qa_results_interface_pkg.Proc1?x=100';
3746:
3747: atchmt := qa_ss_attachment.qa_plans_attachment_status(pid_i);
3748:
3749: OPEN plan_cur(pid_i);
3750: FETCH plan_cur INTO plan_rec;
3751: pname := substr(plan_rec.name,1,30);

Line 3938: procedure VQR_Frames(plan_id_i IN qa_plans.plan_id%TYPE,

3934: htp.p('Exception in QA_SS_CORE.Plan_List_Frames');
3935: htp.p(''||SQLERRM||'');
3936: END Plan_List_Frames;
3937: ----------------------------------------------------------------------------------------------------
3938: procedure VQR_Frames(plan_id_i IN qa_plans.plan_id%TYPE,
3939: ss_where_clause in varchar2 default null)
3940: IS
3941: toolbar_heading VARCHAR2(500);
3942: l_plan_name VARCHAR2(50);

Line 3948: FROM QA_PLANS

3944: ss_w_c varchar2(5000) := NULL;
3945:
3946: CURSOR plan_name_cur IS
3947: SELECT name
3948: FROM QA_PLANS
3949: WHERE plan_id = plan_id_i ;
3950:
3951: BEGIN
3952: if (icx_sec.validateSession) THEN

Line 4137: plan_name_i qa_plans.name%TYPE := NULL;

4133: charid_array qa_ss_const.num_table;
4134: names_array qa_ss_const.var30_table;
4135:
4136: no_of_cols NUMBER := 0;
4137: plan_name_i qa_plans.name%TYPE := NULL;
4138: l_language_code varchar2(30);
4139: it_name VARCHAR2(20);
4140: de_name VARCHAR2(20); -- dependent element name
4141: Name VARCHAR2(2000);

Line 4265: plan_name_i qa_plans.name%TYPE := NULL;

4261: charid_array qa_ss_const.num_table;
4262: names_array qa_ss_const.var30_table;
4263:
4264: no_of_cols NUMBER := 0;
4265: plan_name_i qa_plans.name%TYPE := NULL;
4266: l_language_code varchar2(30);
4267: it_name VARCHAR2(20);
4268: de_name VARCHAR2(20); -- dependent element name
4269: Name VARCHAR2(2000);

Line 4356: plan_name_i qa_plans.name%TYPE := NULL;

4352: charid_array qa_ss_const.num_table;
4353: names_array qa_ss_const.var30_table;
4354:
4355: no_of_cols NUMBER := 0;
4356: plan_name_i qa_plans.name%TYPE := NULL;
4357: l_language_code varchar2(30);
4358: it_name VARCHAR2(20);
4359: de_name VARCHAR2(20); -- dependent element name
4360: Name VARCHAR2(2000);

Line 4442: qa_plans qp,

4438: qpct.Low_Value,
4439: qpct.High_Value
4440: FROM qa_plan_collection_triggers qpct,
4441: qa_plan_transactions qpt,
4442: qa_plans qp,
4443: qa_chars qc,
4444: qa_txn_collection_triggers qtct
4445: WHERE qp.Plan_ID = x_Pid
4446: AND qpt.Plan_ID = qp.Plan_ID