APPS.PA_TRANSACTION_INTERFACE_T3 dependencies on PA_TXN_INT_TRIG_CTL

Line 136: If (pa_txn_int_trig_ctl.G_UserTrxSrc3 = :NEW.user_transaction_source) then

132: PROCEDURE get_trx_source
133: AS
134: BEGIN
135:
136: If (pa_txn_int_trig_ctl.G_UserTrxSrc3 = :NEW.user_transaction_source) then
137:
138: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc4;
139:
140: Else

Line 138: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc4;

134: BEGIN
135:
136: If (pa_txn_int_trig_ctl.G_UserTrxSrc3 = :NEW.user_transaction_source) then
137:
138: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc4;
139:
140: Else
141:
142: X_trx_src := NULL ;

Line 148: pa_txn_int_trig_ctl.G_TrxSrc4 := X_trx_src;

144: INTO X_trx_src
145: FROM pa_transaction_sources
146: WHERE user_transaction_source = :NEW.user_transaction_source ;
147:
148: pa_txn_int_trig_ctl.G_TrxSrc4 := X_trx_src;
149: pa_txn_int_trig_ctl.G_UserTrxSrc3 := :NEW.user_transaction_source;
150:
151: End If;
152:

Line 149: pa_txn_int_trig_ctl.G_UserTrxSrc3 := :NEW.user_transaction_source;

145: FROM pa_transaction_sources
146: WHERE user_transaction_source = :NEW.user_transaction_source ;
147:
148: pa_txn_int_trig_ctl.G_TrxSrc4 := X_trx_src;
149: pa_txn_int_trig_ctl.G_UserTrxSrc3 := :NEW.user_transaction_source;
150:
151: End If;
152:
153: :NEW.transaction_rejection_code := NULL ;

Line 169: If pa_txn_int_trig_ctl.G_TrxSrc5 = :NEW.transaction_source Then

165: PROCEDURE get_system_linkage
166: AS
167: BEGIN
168:
169: If pa_txn_int_trig_ctl.G_TrxSrc5 = :NEW.transaction_source Then
170:
171: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink2;
172:
173: Else

Line 171: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink2;

167: BEGIN
168:
169: If pa_txn_int_trig_ctl.G_TrxSrc5 = :NEW.transaction_source Then
170:
171: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink2;
172:
173: Else
174:
175: X_system_linkage := NULL ;

Line 181: pa_txn_int_trig_ctl.G_SysLink2 := X_system_linkage;

177: INTO X_system_linkage
178: FROM pa_transaction_sources
179: WHERE transaction_source = :NEW.transaction_source ;
180:
181: pa_txn_int_trig_ctl.G_SysLink2 := X_system_linkage;
182: pa_txn_int_trig_ctl.G_TrxSrc5 := :NEW.transaction_source;
183:
184: End If;
185:

Line 182: pa_txn_int_trig_ctl.G_TrxSrc5 := :NEW.transaction_source;

178: FROM pa_transaction_sources
179: WHERE transaction_source = :NEW.transaction_source ;
180:
181: pa_txn_int_trig_ctl.G_SysLink2 := X_system_linkage;
182: pa_txn_int_trig_ctl.G_TrxSrc5 := :NEW.transaction_source;
183:
184: End If;
185:
186: :NEW.transaction_rejection_code := NULL ;

Line 722: pa_txn_int_trig_ctl.batch_name_tbl(pa_txn_int_trig_ctl.idx) := :OLD.batch_name;

718: ,:NEW.CBS_ELEMENT_NAME
719: ) ;
720:
721: --Bug 4686388,4552319)
722: pa_txn_int_trig_ctl.batch_name_tbl(pa_txn_int_trig_ctl.idx) := :OLD.batch_name;
723: pa_txn_int_trig_ctl.expenditure_id(pa_txn_int_trig_ctl.idx) := :OLD.expenditure_id ;
724: pa_txn_int_trig_ctl.idx := pa_txn_int_trig_ctl.idx+1 ;
725:
726: END;

Line 723: pa_txn_int_trig_ctl.expenditure_id(pa_txn_int_trig_ctl.idx) := :OLD.expenditure_id ;

719: ) ;
720:
721: --Bug 4686388,4552319)
722: pa_txn_int_trig_ctl.batch_name_tbl(pa_txn_int_trig_ctl.idx) := :OLD.batch_name;
723: pa_txn_int_trig_ctl.expenditure_id(pa_txn_int_trig_ctl.idx) := :OLD.expenditure_id ;
724: pa_txn_int_trig_ctl.idx := pa_txn_int_trig_ctl.idx+1 ;
725:
726: END;

Line 724: pa_txn_int_trig_ctl.idx := pa_txn_int_trig_ctl.idx+1 ;

720:
721: --Bug 4686388,4552319)
722: pa_txn_int_trig_ctl.batch_name_tbl(pa_txn_int_trig_ctl.idx) := :OLD.batch_name;
723: pa_txn_int_trig_ctl.expenditure_id(pa_txn_int_trig_ctl.idx) := :OLD.expenditure_id ;
724: pa_txn_int_trig_ctl.idx := pa_txn_int_trig_ctl.idx+1 ;
725:
726: END;