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 2050: IF (transaction_number = qa_ss_const.po_inspection_txn) THEN

2046:
2047: BEGIN
2048:
2049:
2050: IF (transaction_number = qa_ss_const.po_inspection_txn) THEN
2051: -- NEED FURTHER WORK: need to validate transaction date
2052: -- in this specific case
2053: result := FALSE;
2054: END IF;

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

2229: END IF;
2230:
2231: -- Only done for WIP Completion and Work Order Less Completions
2232:
2233: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2234: qa_ss_const.flow_work_order_less_txn)) THEN
2235: RETURN TRUE;
2236: END IF;
2237:

Line 2234: qa_ss_const.flow_work_order_less_txn)) THEN

2230:
2231: -- Only done for WIP Completion and Work Order Less Completions
2232:
2233: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2234: qa_ss_const.flow_work_order_less_txn)) THEN
2235: RETURN TRUE;
2236: END IF;
2237:
2238: OPEN c;

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

2282:
2283: -- Bug 3364660. Return TRUE even if the x_transaction_number is NULL.
2284: -- kabalakr.
2285:
2286: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2287: qa_ss_const.flow_work_order_less_txn))
2288: OR (x_transaction_number IS NULL) THEN
2289:
2290: RETURN TRUE;

Line 2287: qa_ss_const.flow_work_order_less_txn))

2283: -- Bug 3364660. Return TRUE even if the x_transaction_number is NULL.
2284: -- kabalakr.
2285:
2286: IF (x_transaction_number NOT IN( qa_ss_const.wip_completion_txn,
2287: qa_ss_const.flow_work_order_less_txn))
2288: OR (x_transaction_number IS NULL) THEN
2289:
2290: RETURN TRUE;
2291: END IF;

Line 5271: IF p_transaction_number = qa_ss_const.wip_completion_txn THEN

5267: result BOOLEAN;
5268: sql_string QA_CHARS.SQL_VALIDATION_STRING%TYPE;
5269:
5270: BEGIN
5271: IF p_transaction_number = qa_ss_const.wip_completion_txn THEN
5272: OPEN C4;
5273: FETCH C4 INTO l_temp;
5274: result := C4%FOUND;
5275: CLOSE C4;

Line 5277: ELSIF p_transaction_number = qa_ss_const.flow_work_order_less_txn THEN

5273: FETCH C4 INTO l_temp;
5274: result := C4%FOUND;
5275: CLOSE C4;
5276:
5277: ELSIF p_transaction_number = qa_ss_const.flow_work_order_less_txn THEN
5278: OPEN C22;
5279: FETCH C22 INTO l_temp;
5280: result := C22%FOUND;
5281: CLOSE C22;

Line 5283: ELSIF p_transaction_number = qa_ss_const.wip_move_txn THEN

5279: FETCH C22 INTO l_temp;
5280: result := C22%FOUND;
5281: CLOSE C22;
5282:
5283: ELSIF p_transaction_number = qa_ss_const.wip_move_txn THEN
5284: OPEN C1;
5285: FETCH C1 INTO l_temp;
5286: result := C1%FOUND;
5287: CLOSE C1;

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

5291: -- method in qa_mqa_mwa_api package.
5292: -- srhariha. Mon Aug 22 02:50:35 PDT 2005.
5293:
5294: ELSIF qa_mqa_mwa_api.is_mobile_txn(p_transaction_number) = fnd_api.g_true THEN
5295: OPEN C_MOBILE(qa_ss_const.mob_txn_lookup_prefix || to_char(p_transaction_number));
5296: FETCH C_MOBILE INTO l_temp;
5297: result := C_MOBILE%FOUND;
5298: CLOSE C_MOBILE;
5299:

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

5298: CLOSE C_MOBILE;
5299:
5300: ELSE
5301:
5302: sql_string := get_sql_validation_string(qa_ss_const.transaction_type);
5303:
5304:
5305: sql_string := qa_chars_api.format_sql_for_validation (sql_string,
5306: p_org_id, p_user_id);

Line 5369: If (p_child_char_id = qa_ss_const.party_name OR

5365: -- bug 6132613
5366: -- Modified to fetch Ids for RMA number
5367: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5368: --
5369: If (p_child_char_id = qa_ss_const.party_name OR
5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR

Line 5370: p_child_char_id = qa_ss_const.po_number OR

5366: -- Modified to fetch Ids for RMA number
5367: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5368: --
5369: If (p_child_char_id = qa_ss_const.party_name OR
5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR
5374: p_child_char_id = qa_ss_const.rma_number ) THEN

Line 5371: p_child_char_id = qa_ss_const.locator OR

5367: -- ntungare Tue Jul 17 22:54:27 PDT 2007
5368: --
5369: If (p_child_char_id = qa_ss_const.party_name OR
5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR
5374: p_child_char_id = qa_ss_const.rma_number ) THEN
5375: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||

Line 5372: p_child_char_id = qa_ss_const.comp_locator OR

5368: --
5369: If (p_child_char_id = qa_ss_const.party_name OR
5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR
5374: p_child_char_id = qa_ss_const.rma_number ) THEN
5375: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5376: ' from qa_results '||

Line 5373: p_child_char_id = qa_ss_const.to_locator OR

5369: If (p_child_char_id = qa_ss_const.party_name OR
5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR
5374: p_child_char_id = qa_ss_const.rma_number ) THEN
5375: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5376: ' from qa_results '||
5377: ' where plan_id = :p_plan_id '||

Line 5374: p_child_char_id = qa_ss_const.rma_number ) THEN

5370: p_child_char_id = qa_ss_const.po_number OR
5371: p_child_char_id = qa_ss_const.locator OR
5372: p_child_char_id = qa_ss_const.comp_locator OR
5373: p_child_char_id = qa_ss_const.to_locator OR
5374: p_child_char_id = qa_ss_const.rma_number ) THEN
5375: str := 'Select '|| qa_chars_api.hardcoded_column(p_child_char_id)||
5376: ' from qa_results '||
5377: ' where plan_id = :p_plan_id '||
5378: ' and collection_id = :p_collection_id '||