DBA Data[Home] [Help]

APPS.IES_TRANSACTION_SEGMENTS_PKG dependencies on IES_TRANSACTION_UTIL_PKG

Line 35: transactionId := ies_transaction_util_pkg.insert_transaction(p_user_id, p_dscript_id);

31: transactionId NUMBER;
32: seqval NUMBER;
33: BEGIN
34: if (p_transaction_id = 0) then
35: transactionId := ies_transaction_util_pkg.insert_transaction(p_user_id, p_dscript_id);
36: else
37: ies_transaction_util_pkg.update_transaction(p_transaction_id, 2, empty_clob(), p_user_id);
38: transactionId := p_transaction_id;
39: end if;

Line 37: ies_transaction_util_pkg.update_transaction(p_transaction_id, 2, empty_clob(), p_user_id);

33: BEGIN
34: if (p_transaction_id = 0) then
35: transactionId := ies_transaction_util_pkg.insert_transaction(p_user_id, p_dscript_id);
36: else
37: ies_transaction_util_pkg.update_transaction(p_transaction_id, 2, empty_clob(), p_user_id);
38: transactionId := p_transaction_id;
39: end if;
40:
41: execute immediate 'select ies_trans_segments_s.nextval from dual' into seqval;

Line 68: ies_transaction_util_pkg.update_transaction(p_transaction_id,

64: sqlstmt VARCHAR2(2000);
65: segmentId number;
66: BEGIN
67: segmentId := getSegmentId(p_transaction_id);
68: ies_transaction_util_pkg.update_transaction(p_transaction_id,
69: p_status,
70: p_restart_clob,
71: p_user_id);
72: sqlStmt := 'update ies_trans_segments set end_time = :1,