APPS.QA_SS_CORE dependencies on QA_CHARS

Line 50: From QA_CHARS

46: l_prompt VARCHAR2(50);
47:
48: CURSOR c IS
49: Select prompt
50: From QA_CHARS
51: WHERE char_id = X_char_id;
52:
53: BEGIN
54: OPEN c;

Line 400: l_prompt VARCHAR2(50):=NULL; -- this is qa_chars.prompt column to show

396:
397: qri_source_code VARCHAR2(30) := NULL;
398: qri_source_line_id NUMBER := NULL;
399:
400: l_prompt VARCHAR2(50):=NULL; -- this is qa_chars.prompt column to show
401: -- collection element prompt for error messages
402:
403: cursor chars_cur IS
404: SELECT qpc.char_id

Line 997: char_name_i qa_chars.name%TYPE;

993: l_language_code varchar2(30);
994: it_name VARCHAR2(20);
995: de_name VARCHAR2(20); -- dependent element name
996: Name VARCHAR2(2000);
997: char_name_i qa_chars.name%TYPE;
998: item_name VARCHAR2(30) := NULL;
999: l_Po_Agent_Id NUMBER := NULL;
1000: l_User_Id NUMBER := NULL;
1001: l_Item_Id NUMBER := NULL;

Line 1029: from qa_plan_chars qpc, qa_chars qc

1025:
1026: CURSOR char_cur IS
1027: select qpc.prompt_sequence, qc.char_id, qc.name, NVL(qc.developer_name, qc.name) AS cname, qc.sql_validation_string, qpc.prompt, qc.display_length, qpc.default_value,
1028: qpc.enabled_flag, qc.data_entry_hint
1029: from qa_plan_chars qpc, qa_chars qc
1030: where qpc.plan_id = plan_id_i
1031: AND qpc.char_id = qc.char_id
1032: AND qpc.enabled_flag = 1
1033: ORDER BY qpc.prompt_sequence;

Line 1365: FROM qa_chars

1361: -- If it is a context element for the given txn, then we
1362: -- return above. Below stmts are not executed
1363:
1364: SELECT values_exist_flag, sql_validation_string INTO inlist_exists,sql_val_st
1365: FROM qa_chars
1366: WHERE char_id = cid;
1367:
1368: if (inlist_exists = 1) then
1369: return TRUE;

Line 1784: from qa_plan_chars qpc, qa_chars qc

1780: ss_w_c varchar2(5000) := NULL;
1781:
1782: CURSOR char_cur IS
1783: select qpc.prompt_sequence, qc.char_id, qc.name, qc.prompt, qpc.enabled_flag
1784: from qa_plan_chars qpc, qa_chars qc
1785: where qpc.plan_id = plan_id_i
1786: AND qpc.char_id = qc.char_id
1787: AND qpc.enabled_flag = 1
1788: ORDER BY qpc.prompt_sequence;

Line 3433: qa_chars qc,

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
3437: AND qpct.Collection_Trigger_ID = qtct.Collection_Trigger_ID(+)

Line 4142: char_name_i qa_chars.name%TYPE;

4138: l_language_code varchar2(30);
4139: it_name VARCHAR2(20);
4140: de_name VARCHAR2(20); -- dependent element name
4141: Name VARCHAR2(2000);
4142: char_name_i qa_chars.name%TYPE;
4143: item_name VARCHAR2(30) := NULL;
4144: l_Po_Agent_Id NUMBER := NULL;
4145: l_User_Id NUMBER := NULL;
4146: l_Item_Id NUMBER := NULL;

Line 4270: char_name_i qa_chars.name%TYPE;

4266: l_language_code varchar2(30);
4267: it_name VARCHAR2(20);
4268: de_name VARCHAR2(20); -- dependent element name
4269: Name VARCHAR2(2000);
4270: char_name_i qa_chars.name%TYPE;
4271: item_name VARCHAR2(30) := NULL;
4272: l_Po_Agent_Id NUMBER := NULL;
4273: l_User_Id NUMBER := NULL;
4274: l_Item_Id NUMBER := NULL;

Line 4361: char_name_i qa_chars.name%TYPE;

4357: l_language_code varchar2(30);
4358: it_name VARCHAR2(20);
4359: de_name VARCHAR2(20); -- dependent element name
4360: Name VARCHAR2(2000);
4361: char_name_i qa_chars.name%TYPE;
4362: item_name VARCHAR2(30) := NULL;
4363: l_Po_Agent_Id NUMBER := NULL;
4364: l_User_Id NUMBER := NULL;
4365: l_Item_Id NUMBER := NULL;

Line 4443: qa_chars qc,

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
4447: AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID