DBA Data[Home] [Help]

APPS.PA_TRANSACTION_INTERFACE_T2 dependencies on PA_TXN_INT_TRIG_CTL

Line 21: If (pa_txn_int_trig_ctl.G_UserTrxSrc1 = :NEW.user_transaction_source) Then

17: PROCEDURE get_trx_source
18: AS
19: BEGIN
20:
21: If (pa_txn_int_trig_ctl.G_UserTrxSrc1 = :NEW.user_transaction_source) Then
22:
23: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc1;
24:
25: Else

Line 23: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc1;

19: BEGIN
20:
21: If (pa_txn_int_trig_ctl.G_UserTrxSrc1 = :NEW.user_transaction_source) Then
22:
23: X_trx_src := pa_txn_int_trig_ctl.G_TrxSrc1;
24:
25: Else
26:
27: X_trx_src := NULL ;

Line 33: pa_txn_int_trig_ctl.G_UserTrxSrc1 := :NEW.user_transaction_source;

29: INTO X_trx_src
30: FROM pa_transaction_sources
31: WHERE user_transaction_source = :NEW.user_transaction_source ;
32:
33: pa_txn_int_trig_ctl.G_UserTrxSrc1 := :NEW.user_transaction_source;
34: pa_txn_int_trig_ctl.G_TrxSrc1 := X_trx_src;
35: End If;
36:
37: :NEW.transaction_rejection_code := NULL ;

Line 34: pa_txn_int_trig_ctl.G_TrxSrc1 := X_trx_src;

30: FROM pa_transaction_sources
31: WHERE user_transaction_source = :NEW.user_transaction_source ;
32:
33: pa_txn_int_trig_ctl.G_UserTrxSrc1 := :NEW.user_transaction_source;
34: pa_txn_int_trig_ctl.G_TrxSrc1 := X_trx_src;
35: End If;
36:
37: :NEW.transaction_rejection_code := NULL ;
38: :NEW.transaction_status_code := 'P' ;

Line 49: If (pa_txn_int_trig_ctl.G_TrxSrc2 = :NEW.transaction_source) Then

45:
46: PROCEDURE get_usr_trx_source
47: AS
48: BEGIN
49: If (pa_txn_int_trig_ctl.G_TrxSrc2 = :NEW.transaction_source) Then
50:
51: X_usr_trx_src := pa_txn_int_trig_ctl.G_UserTrxSrc2;
52:
53: Else

Line 51: X_usr_trx_src := pa_txn_int_trig_ctl.G_UserTrxSrc2;

47: AS
48: BEGIN
49: If (pa_txn_int_trig_ctl.G_TrxSrc2 = :NEW.transaction_source) Then
50:
51: X_usr_trx_src := pa_txn_int_trig_ctl.G_UserTrxSrc2;
52:
53: Else
54:
55: X_trx_src := NULL ;

Line 61: pa_txn_int_trig_ctl.G_TrxSrc2 := :NEW.transaction_source;

57: INTO X_usr_trx_src
58: FROM pa_transaction_sources
59: WHERE transaction_source = :NEW.transaction_source ;
60:
61: pa_txn_int_trig_ctl.G_TrxSrc2 := :NEW.transaction_source;
62: pa_txn_int_trig_ctl.G_UserTrxSrc2 := X_usr_trx_src;
63:
64: End If;
65:

Line 62: pa_txn_int_trig_ctl.G_UserTrxSrc2 := X_usr_trx_src;

58: FROM pa_transaction_sources
59: WHERE transaction_source = :NEW.transaction_source ;
60:
61: pa_txn_int_trig_ctl.G_TrxSrc2 := :NEW.transaction_source;
62: pa_txn_int_trig_ctl.G_UserTrxSrc2 := X_usr_trx_src;
63:
64: End If;
65:
66: :NEW.transaction_rejection_code := NULL ;

Line 82: If pa_txn_int_trig_ctl.G_TrxSrc3 = :NEW.transaction_source Then

78: PROCEDURE get_system_linkage
79: AS
80: BEGIN
81:
82: If pa_txn_int_trig_ctl.G_TrxSrc3 = :NEW.transaction_source Then
83:
84: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink1;
85:
86: Else

Line 84: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink1;

80: BEGIN
81:
82: If pa_txn_int_trig_ctl.G_TrxSrc3 = :NEW.transaction_source Then
83:
84: X_system_linkage := pa_txn_int_trig_ctl.G_SysLink1;
85:
86: Else
87:
88: X_system_linkage := NULL ;

Line 94: pa_txn_int_trig_ctl.G_SysLink1 := X_system_linkage;

90: INTO X_system_linkage
91: FROM pa_transaction_sources
92: WHERE transaction_source = :NEW.transaction_source ;
93:
94: pa_txn_int_trig_ctl.G_SysLink1 := X_system_linkage;
95: pa_txn_int_trig_ctl.G_TrxSrc3 := :NEW.transaction_source;
96: End If;
97:
98: :NEW.transaction_rejection_code := NULL ;

Line 95: pa_txn_int_trig_ctl.G_TrxSrc3 := :NEW.transaction_source;

91: FROM pa_transaction_sources
92: WHERE transaction_source = :NEW.transaction_source ;
93:
94: pa_txn_int_trig_ctl.G_SysLink1 := X_system_linkage;
95: pa_txn_int_trig_ctl.G_TrxSrc3 := :NEW.transaction_source;
96: End If;
97:
98: :NEW.transaction_rejection_code := NULL ;
99: :NEW.transaction_status_code := 'P' ;