DBA Data[Home] [Help]

APPS.QLTTRAWB dependencies on QA_PARENT_CHILD_PKG

Line 8156: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;

8152: -- scanario the following call added.
8153: -- rponnusa Wed Apr 24 12:19:54 PDT 2002
8154:
8155: -- Bug 8586750.FP of 8321226.Added this code in transaction Worker hence removing here.
8156: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;
8157: -- pdube Mon Jun 15 23:07:13 PDT 2009
8158: EXCEPTION
8159:
8160: WHEN resource_busy THEN

Line 8570: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 2) ;

8566: -- scanario the following call added.
8567: -- rponnusa Wed Apr 24 12:19:54 PDT 2002
8568:
8569: -- Bug 8586750.FP of 8321226.Added this code in transaction Worker hence removing here.
8570: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 2) ;
8571: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;
8572: -- pdube Mon Jun 15 23:07:13 PDT 2009
8573: Exception
8574: when others then

Line 8571: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;

8567: -- rponnusa Wed Apr 24 12:19:54 PDT 2002
8568:
8569: -- Bug 8586750.FP of 8321226.Added this code in transaction Worker hence removing here.
8570: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 2) ;
8571: -- QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;
8572: -- pdube Mon Jun 15 23:07:13 PDT 2009
8573: Exception
8574: when others then
8575: QLTTRAMB.qa_import_log('Exception in TRANSFER_VALID_ROWS :'||sqlerrm(sqlcode));

Line 9311: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;

9307: BEGIN
9308: -- Bug 8586750.Fp for 8321226.Added this condition for creating automatic/history records
9309: -- for update(type_of_txn=2) and insert(type_of_txn=1) transactions.
9310: IF P_TYPE_OF_TXN = 2 THEN
9311: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9312: ELSE
9313: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 2) ;
9314: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9315:

Line 9313: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 2) ;

9309: -- for update(type_of_txn=2) and insert(type_of_txn=1) transactions.
9310: IF P_TYPE_OF_TXN = 2 THEN
9311: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9312: ELSE
9313: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 2) ;
9314: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9315:
9316: --
9317: --

Line 9314: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;

9310: IF P_TYPE_OF_TXN = 2 THEN
9311: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9312: ELSE
9313: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 2) ;
9314: QA_PARENT_CHILD_PKG.insert_history_auto_rec(P_PLAN_ID, P_TXN_HEADER_ID, 1, 4) ;
9315:
9316: --
9317: --
9318: -- bug 13418140

Line 9323: l_ret_val := QA_PARENT_CHILD_PKG.update_all_children(P_PLAN_ID,

9319: -- Cursor to update the child records post
9320: -- action firing
9321: --
9322: FOR import_rec IN res_cur LOOP
9323: l_ret_val := QA_PARENT_CHILD_PKG.update_all_children(P_PLAN_ID,
9324: import_rec.collection_id,
9325: import_rec.occurrence);
9326: END LOOP;
9327: END IF;