DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_PKG dependencies on QA_SS_CONST

Line 3077: (parent_rec.datatype = qa_ss_const.datetime_datatype) THEN

3073:
3074: -- Bug 3424886 ksoh Mon Feb 9 13:39:41 PST 2004
3075: -- need to convert hardcoded dates to canonical string
3076: ELSIF (substr(column_name, 1, 9) <> 'CHARACTER') AND
3077: (parent_rec.datatype = qa_ss_const.datetime_datatype) THEN
3078: column_name := 'FND_DATE.DATE_TO_CANONICAL(' || column_name || ')';
3079: END IF;
3080: --
3081: -- bug 6266477

Line 3125: /*IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,

3121: */
3122: -- Bug 6266477
3123: -- Commented below code.
3124: -- skollluku Mon Oct 15 02:57:40 PDT 2007
3125: /*IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3126: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3127: l_res_value := qa_flex_util.item(p_organization_id , l_res_value);
3128:
3129: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,

Line 3126: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN

3122: -- Bug 6266477
3123: -- Commented below code.
3124: -- skollluku Mon Oct 15 02:57:40 PDT 2007
3125: /*IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3126: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3127: l_res_value := qa_flex_util.item(p_organization_id , l_res_value);
3128:
3129: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3130: qa_ss_const.to_locator) THEN

Line 3129: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,

3125: /*IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3126: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3127: l_res_value := qa_flex_util.item(p_organization_id , l_res_value);
3128:
3129: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3130: qa_ss_const.to_locator) THEN
3131: l_res_value := qa_flex_util.locator(p_organization_id, l_res_value);
3132: END IF;
3133:

Line 3130: qa_ss_const.to_locator) THEN

3126: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3127: l_res_value := qa_flex_util.item(p_organization_id , l_res_value);
3128:
3129: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3130: qa_ss_const.to_locator) THEN
3131: l_res_value := qa_flex_util.locator(p_organization_id, l_res_value);
3132: END IF;
3133:
3134: -- Bug 2403395

Line 3147: IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,

3143: -- Added the below code to enhance performance
3144: -- by hitting the view QA_RESULTS_V just once
3145: -- skolluku Mon Oct 15 02:57:40 PDT 2007
3146: --
3147: IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3148: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3149: column_name := 'qa_flex_util.item(' || p_organization_id || ', ' || column_name || ')';
3150:
3151: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,

Line 3148: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN

3144: -- by hitting the view QA_RESULTS_V just once
3145: -- skolluku Mon Oct 15 02:57:40 PDT 2007
3146: --
3147: IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3148: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3149: column_name := 'qa_flex_util.item(' || p_organization_id || ', ' || column_name || ')';
3150:
3151: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3152: qa_ss_const.to_locator) THEN

Line 3151: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,

3147: IF parent_rec.char_id IN (qa_ss_const.item, qa_ss_const.comp_item,
3148: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3149: column_name := 'qa_flex_util.item(' || p_organization_id || ', ' || column_name || ')';
3150:
3151: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3152: qa_ss_const.to_locator) THEN
3153: column_name := 'qa_flex_util.locator(' || p_organization_id || ', ' || column_name || ')';
3154: END IF;
3155:

Line 3152: qa_ss_const.to_locator) THEN

3148: qa_ss_const.routing_reference, qa_ss_const.bill_reference) THEN
3149: column_name := 'qa_flex_util.item(' || p_organization_id || ', ' || column_name || ')';
3150:
3151: ELSIF parent_rec.char_id IN (qa_ss_const.locator, qa_ss_const.comp_locator,
3152: qa_ss_const.to_locator) THEN
3153: column_name := 'qa_flex_util.locator(' || p_organization_id || ', ' || column_name || ')';
3154: END IF;
3155:
3156: column_name := 'replace(' || column_name || ', ''@'', ''@@'')';