DBA Data[Home] [Help]

APPS.QA_JRAD_PKG dependencies on QA_PLAN_ELEMENT_API

Line 80: IF (qa_plan_element_api.element_in_plan(p_plan_id,

76: -- for customer portal (OM). This can be determined
77: -- by checking if sales order is a part of the plan
78: -- and enabled.
79:
80: IF (qa_plan_element_api.element_in_plan(p_plan_id,
81: qa_ss_const.sales_order)) THEN
82: RETURN TRUE;
83: ELSE
84: RETURN FALSE;

Line 262: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache

258: END retrieve_id;
259:
260: -- Bug 3769260. shkalyan 29 July 2004.
261: -- Removed the get_label function which was getting prompt from
262: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
263:
264: /*
265: FUNCTION get_label (p_plan_id IN NUMBER, p_element_id IN NUMBER)
266: RETURN VARCHAR2 IS

Line 492: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)

488:
489: IF context_element(p_element_id, l_txn_number) THEN
490: return 'formValue';
491: ELSIF
492: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)
493: OR qa_plan_element_api.sql_validation_exists(p_element_id)
494: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN
495: return 'messageLovInput';
496: ELSE

Line 493: OR qa_plan_element_api.sql_validation_exists(p_element_id)

489: IF context_element(p_element_id, l_txn_number) THEN
490: return 'formValue';
491: ELSIF
492: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)
493: OR qa_plan_element_api.sql_validation_exists(p_element_id)
494: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN
495: return 'messageLovInput';
496: ELSE
497:

Line 996: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,

992: -- anagarwa
993: -- Bug 2751198
994: -- Add dependency to LOV only if the element exists in the plan
995: -- This is achieved by adding the following IF statement
996: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
997: -- l_parents(i)) THEN
998:
999: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
1000: -- array might not have been initialized. use element_in_plan

Line 1002: IF qa_plan_element_api.element_in_plan(p_plan_id,

998:
999: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
1000: -- array might not have been initialized. use element_in_plan
1001:
1002: IF qa_plan_element_api.element_in_plan(p_plan_id,
1003: l_parents(i)) THEN
1004:
1005: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);
1006: --

Line 1219: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);

1215: l_uom_code qa_plan_chars.uom_code%TYPE;
1216: BEGIN
1217: -- The function is the standard way to compute prompt
1218: -- taking uom_code into account
1219: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);
1220: l_uom_code := qa_plan_element_api.get_uom_code(p_plan_id, p_char_id);
1221:
1222: IF (l_uom_code is not null) THEN
1223: RETURN l_prompt || ' (' || l_uom_code || ')';

Line 1220: l_uom_code := qa_plan_element_api.get_uom_code(p_plan_id, p_char_id);

1216: BEGIN
1217: -- The function is the standard way to compute prompt
1218: -- taking uom_code into account
1219: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);
1220: l_uom_code := qa_plan_element_api.get_uom_code(p_plan_id, p_char_id);
1221:
1222: IF (l_uom_code is not null) THEN
1223: RETURN l_prompt || ' (' || l_uom_code || ')';
1224: ELSE

Line 1270: -- and qa_plan_element_api are used instead.

1266: l_readonly_flag VARCHAR2(10);
1267:
1268: -- Bug 3769260. shkalyan 29 July 2004.
1269: -- Removed these cursors so that the cached arrays of qa_chars_api
1270: -- and qa_plan_element_api are used instead.
1271: /*
1272: CURSOR c1 IS
1273: SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
1274: FROM qa_plan_chars

Line 1298: -- and qa_plan_element_api are used instead.

1294: BEGIN
1295:
1296: -- Bug 3769260. shkalyan 29 July 2004.
1297: -- Removed these cursors so that the cached arrays of qa_chars_api
1298: -- and qa_plan_element_api are used instead.
1299: /*
1300: OPEN c1;
1301: FETCH c1 INTO c_displayed_flag, c_mandatory_flag, c_prompt, c_readonly_flag;
1302: CLOSE c1;

Line 1316: l_display_flag := convert_boolean_flag( qa_plan_element_api.qpc_displayed_flag( p_plan_id, p_char_id ) );

1312: l_attribute_code := construct_jrad_code(g_element_prefix, p_char_id);
1313:
1314: l_vo_attribute_name := get_vo_attribute_name(p_char_id, p_plan_id);
1315:
1316: l_display_flag := convert_boolean_flag( qa_plan_element_api.qpc_displayed_flag( p_plan_id, p_char_id ) );
1317:
1318: l_required_flag := convert_yesno_flag( qa_plan_element_api.qpc_mandatory_flag( p_plan_id, p_char_id ) );
1319:
1320: l_data_type := convert_data_type( qa_chars_api.datatype( p_char_id ) );

Line 1318: l_required_flag := convert_yesno_flag( qa_plan_element_api.qpc_mandatory_flag( p_plan_id, p_char_id ) );

1314: l_vo_attribute_name := get_vo_attribute_name(p_char_id, p_plan_id);
1315:
1316: l_display_flag := convert_boolean_flag( qa_plan_element_api.qpc_displayed_flag( p_plan_id, p_char_id ) );
1317:
1318: l_required_flag := convert_yesno_flag( qa_plan_element_api.qpc_mandatory_flag( p_plan_id, p_char_id ) );
1319:
1320: l_data_type := convert_data_type( qa_chars_api.datatype( p_char_id ) );
1321:
1322: l_item_style := compute_item_style(p_prefix, p_char_id, p_plan_id);

Line 1328: l_readonly_flag := convert_boolean_flag( qa_plan_element_api.qpc_read_only_flag( p_plan_id, p_char_id ) );

1324: -- Tracking Bug : 3104827
1325: -- Added for Read Only Flag Collection Plan Enhancement
1326: -- saugupta Thu Aug 28 08:59:59 PDT 2003
1327:
1328: l_readonly_flag := convert_boolean_flag( qa_plan_element_api.qpc_read_only_flag( p_plan_id, p_char_id ) );
1329:
1330: -- Bug 5455658. SHKALYAN 20-Sep-2006
1331: -- modified to invoke a local function which calls
1332: -- qa_plan_element_api.get_prompt instead of

Line 1332: -- qa_plan_element_api.get_prompt instead of

1328: l_readonly_flag := convert_boolean_flag( qa_plan_element_api.qpc_read_only_flag( p_plan_id, p_char_id ) );
1329:
1330: -- Bug 5455658. SHKALYAN 20-Sep-2006
1331: -- modified to invoke a local function which calls
1332: -- qa_plan_element_api.get_prompt instead of
1333: -- qa_chars_api.prompt because the latter would always return the prompt
1334: -- defined at the element level only and this is not desired.
1335: -- l_prompt := qa_chars_api.prompt( p_char_id );
1336: l_prompt := get_prompt(p_plan_id, p_char_id);

Line 1461: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache

1457: l_data_type := convert_data_type(qa_chars_api.datatype(p_char_id));
1458:
1459: -- Bug 3769260. shkalyan 29 July 2004.
1460: -- Removed the get_label function which was getting prompt from
1461: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1462:
1463: -- Bug 5455658. SHKALYAN 20-Sep-2006
1464: -- modified to invoke a local function which calls
1465: -- qa_plan_element_api.get_prompt and concatenates the UOM

Line 1465: -- qa_plan_element_api.get_prompt and concatenates the UOM

1461: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1462:
1463: -- Bug 5455658. SHKALYAN 20-Sep-2006
1464: -- modified to invoke a local function which calls
1465: -- qa_plan_element_api.get_prompt and concatenates the UOM
1466: l_label_long := get_prompt(p_plan_id, l_element_id);
1467:
1468: -- item_style is HIDDEN and if this element is a context element
1469: -- and is a query criteria (search flag is 1) for vqr