14: dummy NUMBER;
15:
16: CURSOR c IS
17: SELECT 1
18: FROM qa_plan_transactions
19: WHERE plan_id = p_plan_id
20: AND transaction_number = qa_ss_const.ss_outside_processing_txn
21: AND enabled_flag = 1;
22:
42: dummy NUMBER;
43:
44: CURSOR c IS
45: SELECT 1
46: FROM qa_plan_transactions
47: WHERE plan_id = p_plan_id
48: AND transaction_number = qa_ss_const.ss_shipments_txn
49: AND enabled_flag = 1;
50:
87: RETURN BOOLEAN IS
88:
89: CURSOR c IS
90: SELECT 1
91: FROM qa_plan_transactions
92: WHERE plan_id = p_plan_id
93: AND transaction_number = 31
94: AND enabled_flag = 1;
95:
117: RETURN BOOLEAN IS
118:
119: CURSOR c IS
120: SELECT 1
121: FROM qa_plan_transactions
122: WHERE plan_id = p_plan_id
123: AND transaction_number = 32
124: AND enabled_flag = 1;
125:
147: RETURN BOOLEAN IS
148:
149: CURSOR c IS
150: SELECT 1
151: FROM qa_plan_transactions
152: WHERE plan_id = p_plan_id
153: AND transaction_number = 33
154: AND enabled_flag = 1;
155: