DBA Data[Home] [Help]

APPS.QA_AK_MAPPING_API dependencies on DUAL

Line 686: FROM DUAL

682: RETURN BOOLEAN IS
683:
684: CURSOR c IS
685: SELECT 1
686: FROM DUAL
687: WHERE p_char_id
688: IN
689: (SELECT assigned_char_id
690: FROM qa_plan_char_actions

Line 927: -- Deletes an individual row from lov relations table.

923: AND direction_flag = p_direction_flag ;
924:
925: BEGIN
926:
927: -- Deletes an individual row from lov relations table.
928: -- Here the region item corresponds to a collection plan element.
929:
930: OPEN c;
931: FETCH c INTO l_row_exists;

Line 3000: -- individual mapping per transaction at a time.

2996: BEGIN
2997:
2998: -- This procedure deletes the mapping of a collection
2999: -- plan from ak tables. This does it by deleting all the
3000: -- individual mapping per transaction at a time.
3001:
3002: -- Even for the same txn the call needs to be made multiple times
3003: -- for example for ship txn, call made once for EQR and once for VQR
3004: -- with appendix g_txn_ship_appendix and g_ship_vqr_appendix