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 483: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)

479:
480: IF context_element(p_element_id, l_txn_number) THEN
481: return 'formValue';
482: ELSIF
483: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)
484: OR qa_plan_element_api.sql_validation_exists(p_element_id)
485: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN
486: return 'messageLovInput';
487: ELSE

Line 484: OR qa_plan_element_api.sql_validation_exists(p_element_id)

480: IF context_element(p_element_id, l_txn_number) THEN
481: return 'formValue';
482: ELSIF
483: (qa_plan_element_api.values_exist(p_plan_id, p_element_id)
484: OR qa_plan_element_api.sql_validation_exists(p_element_id)
485: OR qa_chars_api.has_hardcoded_lov(p_element_id)) THEN
486: return 'messageLovInput';
487: ELSE
488:

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

962: -- anagarwa
963: -- Bug 2751198
964: -- Add dependency to LOV only if the element exists in the plan
965: -- This is achieved by adding the following IF statement
966: -- IF qa_plan_element_api.exists_qa_plan_chars(p_plan_id,
967: -- l_parents(i)) THEN
968:
969: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
970: -- array might not have been initialized. use element_in_plan

Line 972: IF qa_plan_element_api.element_in_plan(p_plan_id,

968:
969: -- rkaza. 10/22/2003. 3209804. shold not use exists_qa_plan_chars
970: -- array might not have been initialized. use element_in_plan
971:
972: IF qa_plan_element_api.element_in_plan(p_plan_id,
973: l_parents(i)) THEN
974:
975: l_lov_attribute_code := g_lov_attribute_dependency || to_char(i);
976: --

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

1185: l_uom_code qa_plan_chars.uom_code%TYPE;
1186: BEGIN
1187: -- The function is the standard way to compute prompt
1188: -- taking uom_code into account
1189: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);
1190: l_uom_code := qa_plan_element_api.get_uom_code(p_plan_id, p_char_id);
1191:
1192: IF (l_uom_code is not null) THEN
1193: RETURN l_prompt || ' (' || l_uom_code || ')';

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

1186: BEGIN
1187: -- The function is the standard way to compute prompt
1188: -- taking uom_code into account
1189: l_prompt := qa_plan_element_api.get_prompt(p_plan_id, p_char_id);
1190: l_uom_code := qa_plan_element_api.get_uom_code(p_plan_id, p_char_id);
1191:
1192: IF (l_uom_code is not null) THEN
1193: RETURN l_prompt || ' (' || l_uom_code || ')';
1194: ELSE

Line 1240: -- and qa_plan_element_api are used instead.

1236: l_readonly_flag VARCHAR2(10);
1237:
1238: -- Bug 3769260. shkalyan 29 July 2004.
1239: -- Removed these cursors so that the cached arrays of qa_chars_api
1240: -- and qa_plan_element_api are used instead.
1241: /*
1242: CURSOR c1 IS
1243: SELECT displayed_flag, mandatory_flag, prompt, read_only_flag
1244: FROM qa_plan_chars

Line 1261: -- and qa_plan_element_api are used instead.

1257: BEGIN
1258:
1259: -- Bug 3769260. shkalyan 29 July 2004.
1260: -- Removed these cursors so that the cached arrays of qa_chars_api
1261: -- and qa_plan_element_api are used instead.
1262: /*
1263: OPEN c1;
1264: FETCH c1 INTO c_displayed_flag, c_mandatory_flag, c_prompt, c_readonly_flag;
1265: CLOSE c1;

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

1275: l_attribute_code := construct_jrad_code(g_element_prefix, p_char_id);
1276:
1277: l_vo_attribute_name := get_vo_attribute_name(p_char_id, p_plan_id);
1278:
1279: l_display_flag := convert_boolean_flag( qa_plan_element_api.qpc_displayed_flag( p_plan_id, p_char_id ) );
1280:
1281: l_required_flag := convert_yesno_flag( qa_plan_element_api.qpc_mandatory_flag( p_plan_id, p_char_id ) );
1282:
1283: l_data_type := convert_data_type( qa_chars_api.datatype( p_char_id ) );

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

1277: l_vo_attribute_name := get_vo_attribute_name(p_char_id, p_plan_id);
1278:
1279: l_display_flag := convert_boolean_flag( qa_plan_element_api.qpc_displayed_flag( p_plan_id, p_char_id ) );
1280:
1281: l_required_flag := convert_yesno_flag( qa_plan_element_api.qpc_mandatory_flag( p_plan_id, p_char_id ) );
1282:
1283: l_data_type := convert_data_type( qa_chars_api.datatype( p_char_id ) );
1284:
1285: l_item_style := compute_item_style(p_prefix, p_char_id, p_plan_id);

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

1287: -- Tracking Bug : 3104827
1288: -- Added for Read Only Flag Collection Plan Enhancement
1289: -- saugupta Thu Aug 28 08:59:59 PDT 2003
1290:
1291: l_readonly_flag := convert_boolean_flag( qa_plan_element_api.qpc_read_only_flag( p_plan_id, p_char_id ) );
1292:
1293: -- Bug 5455658. SHKALYAN 20-Sep-2006
1294: -- modified to invoke a local function which calls
1295: -- qa_plan_element_api.get_prompt instead of

Line 1295: -- qa_plan_element_api.get_prompt instead of

1291: l_readonly_flag := convert_boolean_flag( qa_plan_element_api.qpc_read_only_flag( p_plan_id, p_char_id ) );
1292:
1293: -- Bug 5455658. SHKALYAN 20-Sep-2006
1294: -- modified to invoke a local function which calls
1295: -- qa_plan_element_api.get_prompt instead of
1296: -- qa_chars_api.prompt because the latter would always return the prompt
1297: -- defined at the element level only and this is not desired.
1298: -- l_prompt := qa_chars_api.prompt( p_char_id );
1299: l_prompt := get_prompt(p_plan_id, p_char_id);

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

1400: l_data_type := convert_data_type(qa_chars_api.datatype(p_char_id));
1401:
1402: -- Bug 3769260. shkalyan 29 July 2004.
1403: -- Removed the get_label function which was getting prompt from
1404: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1405:
1406: -- Bug 5455658. SHKALYAN 20-Sep-2006
1407: -- modified to invoke a local function which calls
1408: -- qa_plan_element_api.get_prompt and concatenates the UOM

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

1404: -- qa_plan_chars. Using the qa_plan_element_api function to utilize cache
1405:
1406: -- Bug 5455658. SHKALYAN 20-Sep-2006
1407: -- modified to invoke a local function which calls
1408: -- qa_plan_element_api.get_prompt and concatenates the UOM
1409: l_label_long := get_prompt(p_plan_id, l_element_id);
1410:
1411: -- item_style is HIDDEN and if this element is a context element
1412: -- and is a query criteria (search flag is 1) for vqr