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_PLAN_ELEMENT_API dependencies on QA_SS_CONST

Line 140: i := mod(plan_id * qa_ss_const.max_elements + element_id,

136: -- spec_element_index for use by the spec_element array.
137: -- bso Sun Dec 1 17:39:18 PST 2002
138: --
139:
140: i := mod(plan_id * qa_ss_const.max_elements + element_id,
141: 2147483647);
142:
143: LOOP
144: IF NOT x_qa_plan_chars_array.EXISTS(i) THEN

Line 167: i := mod(p_spec_id * qa_ss_const.max_elements + p_element_id,

163: BEGIN
164: -- Bug 2465704
165: -- See comments in plan_element_index.
166:
167: i := mod(p_spec_id * qa_ss_const.max_elements + p_element_id,
168: 2147483647);
169:
170: LOOP
171: IF NOT x_qa_spec_chars_array.EXISTS(i) THEN

Line 613: RETURN element_id IN (qa_ss_const.item, qa_ss_const.locator,

609:
610: -- added the following to include new hardcoded element followup activity
611: -- saugupta Aug 2003
612:
613: RETURN element_id IN (qa_ss_const.item, qa_ss_const.locator,
614: qa_ss_const.comp_item, qa_ss_const.comp_locator, qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity, qa_ss_const.bill_reference, qa_ss_const.routing_reference, qa_ss_const.to_locator);
615: END keyflex;
616:
617:

Line 614: qa_ss_const.comp_item, qa_ss_const.comp_locator, qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity, qa_ss_const.bill_reference, qa_ss_const.routing_reference, qa_ss_const.to_locator);

610: -- added the following to include new hardcoded element followup activity
611: -- saugupta Aug 2003
612:
613: RETURN element_id IN (qa_ss_const.item, qa_ss_const.locator,
614: qa_ss_const.comp_item, qa_ss_const.comp_locator, qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity, qa_ss_const.bill_reference, qa_ss_const.routing_reference, qa_ss_const.to_locator);
615: END keyflex;
616:
617:
618: FUNCTION normalized (element_id IN NUMBER)

Line 1000: RETURN qa_ss_const.character_datatype;

996:
997: BEGIN
998:
999: IF NOT hardcoded(element_id) THEN
1000: RETURN qa_ss_const.character_datatype;
1001:
1002: ELSIF NOT primitive(element_id) THEN
1003: RETURN qa_ss_const.number_datatype;
1004:

Line 1003: RETURN qa_ss_const.number_datatype;

999: IF NOT hardcoded(element_id) THEN
1000: RETURN qa_ss_const.character_datatype;
1001:
1002: ELSIF NOT primitive(element_id) THEN
1003: RETURN qa_ss_const.number_datatype;
1004:
1005: ELSE
1006: RETURN qa_chars_api.datatype(element_id);
1007:

Line 2031: IF (transaction_number = qa_ss_const.po_inspection_txn) THEN

2027:
2028: BEGIN
2029:
2030:
2031: IF (transaction_number = qa_ss_const.po_inspection_txn) THEN
2032: -- NEED FURTHER WORK: need to validate transaction date
2033: -- in this specific case
2034: result := FALSE;
2035: END IF;

Line 2214: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,

2210: END IF;
2211:
2212: -- Only done for WIP Completion and Work Order Less Completions
2213:
2214: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2215: qa_ss_const.flow_work_order_less_txn)) THEN
2216: RETURN TRUE;
2217: END IF;
2218:

Line 2215: qa_ss_const.flow_work_order_less_txn)) THEN

2211:
2212: -- Only done for WIP Completion and Work Order Less Completions
2213:
2214: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2215: qa_ss_const.flow_work_order_less_txn)) THEN
2216: RETURN TRUE;
2217: END IF;
2218:
2219: OPEN c;

Line 2267: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,

2263:
2264: -- Bug 3364660. Return TRUE even if the x_transaction_number is NULL.
2265: -- kabalakr.
2266:
2267: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2268: qa_ss_const.flow_work_order_less_txn))
2269: OR (x_transaction_number IS NULL) THEN
2270:
2271: RETURN TRUE;

Line 2268: qa_ss_const.flow_work_order_less_txn))

2264: -- Bug 3364660. Return TRUE even if the x_transaction_number is NULL.
2265: -- kabalakr.
2266:
2267: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2268: qa_ss_const.flow_work_order_less_txn))
2269: OR (x_transaction_number IS NULL) THEN
2270:
2271: RETURN TRUE;
2272: END IF;

Line 5073: IF p_transaction_number = qa_ss_const.wip_completion_txn THEN

5069: result BOOLEAN;
5070: sql_string QA_CHARS.SQL_VALIDATION_STRING%TYPE;
5071:
5072: BEGIN
5073: IF p_transaction_number = qa_ss_const.wip_completion_txn THEN
5074: OPEN C4;
5075: FETCH C4 INTO l_temp;
5076: result := C4%FOUND;
5077: CLOSE C4;

Line 5079: ELSIF p_transaction_number = qa_ss_const.flow_work_order_less_txn THEN

5075: FETCH C4 INTO l_temp;
5076: result := C4%FOUND;
5077: CLOSE C4;
5078:
5079: ELSIF p_transaction_number = qa_ss_const.flow_work_order_less_txn THEN
5080: OPEN C22;
5081: FETCH C22 INTO l_temp;
5082: result := C22%FOUND;
5083: CLOSE C22;

Line 5085: ELSIF p_transaction_number = qa_ss_const.wip_move_txn THEN

5081: FETCH C22 INTO l_temp;
5082: result := C22%FOUND;
5083: CLOSE C22;
5084:
5085: ELSIF p_transaction_number = qa_ss_const.wip_move_txn THEN
5086: OPEN C1;
5087: FETCH C1 INTO l_temp;
5088: result := C1%FOUND;
5089: CLOSE C1;

Line 5097: OPEN C_MOBILE(qa_ss_const.mob_txn_lookup_prefix || to_char(p_transaction_number));

5093: -- method in qa_mqa_mwa_api package.
5094: -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
5095:
5096: ELSIF qa_mqa_mwa_api.is_mobile_txn(p_transaction_number) = fnd_api.g_true THEN
5097: OPEN C_MOBILE(qa_ss_const.mob_txn_lookup_prefix || to_char(p_transaction_number));
5098: FETCH C_MOBILE INTO l_temp;
5099: result := C_MOBILE%FOUND;
5100: CLOSE C_MOBILE;
5101:

Line 5104: sql_string := get_sql_validation_string(qa_ss_const.transaction_type);

5100: CLOSE C_MOBILE;
5101:
5102: ELSE
5103:
5104: sql_string := get_sql_validation_string(qa_ss_const.transaction_type);
5105:
5106:
5107: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
5108: p_org_id, p_user_id);

Line 5171: If (p_child_char_id = qa_ss_const.party_name OR

5167: -- bug 6132613
5168: -- Modified to fetch Ids for RMA number
5169: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5170: --
5171: If (p_child_char_id = qa_ss_const.party_name OR
5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR

Line 5172: p_child_char_id = qa_ss_const.po_number OR

5168: -- Modified to fetch Ids for RMA number
5169: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5170: --
5171: If (p_child_char_id = qa_ss_const.party_name OR
5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN

Line 5173: p_child_char_id = qa_ss_const.locator OR

5169: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5170: --
5171: If (p_child_char_id = qa_ss_const.party_name OR
5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN
5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||

Line 5174: p_child_char_id = qa_ss_const.comp_locator OR

5170: --
5171: If (p_child_char_id = qa_ss_const.party_name OR
5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN
5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5178: ' from qa_results '||

Line 5175: p_child_char_id = qa_ss_const.to_locator OR

5171: If (p_child_char_id = qa_ss_const.party_name OR
5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN
5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5178: ' from qa_results '||
5179: ' where plan_id = :p_plan_id '||

Line 5176: p_child_char_id = qa_ss_const.rma_number ) THEN

5172: p_child_char_id = qa_ss_const.po_number OR
5173: p_child_char_id = qa_ss_const.locator OR
5174: p_child_char_id = qa_ss_const.comp_locator OR
5175: p_child_char_id = qa_ss_const.to_locator OR
5176: p_child_char_id = qa_ss_const.rma_number ) THEN
5177: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5178: ' from qa_results '||
5179: ' where plan_id = :p_plan_id '||
5180: ' and collection_id = :p_collection_id '||