eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 42: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,

38:
39: -- Bug : 8763944
40: --Added last two columns in rec to get trxn_core info.
41: TYPE FuncCaptureOrder_rec_type IS RECORD (
42: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
43: -- From IBY_FNDCPT_TX_EXTENSIONS
44: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
45: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
46: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,

Line 51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

47: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
48: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
49: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
50: -- From the ORDERS View
51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,

Line 52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,

48: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
49: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
50: -- From the ORDERS View
51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),

Line 53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,

49: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
50: -- From the ORDERS View
51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),
57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,

Line 54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,

50: -- From the ORDERS View
51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),
57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,

Line 55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,

51: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
52: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),
57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,

Line 57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,

53: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),
57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

Line 58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,

54: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
55: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
56: ORDER_DESCRIPTION VARCHAR2(255),
57: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,

Line 62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,

58: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,

Line 63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,

59: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,

Line 64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,

60: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,

Line 65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,

61: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,

Line 66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,

62: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,

Line 67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,

63: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,

Line 68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,

64: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
72: BR_DISPUTED_FLAG VARCHAR2(1),

Line 69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,

65: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
72: BR_DISPUTED_FLAG VARCHAR2(1),
73: ATTRIBUTE_CATEGORY VARCHAR2(150),

Line 70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,

66: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
72: BR_DISPUTED_FLAG VARCHAR2(1),
73: ATTRIBUTE_CATEGORY VARCHAR2(150),
74: ATTRIBUTE1 VARCHAR2(150),

Line 71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,

67: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
68: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
69: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
70: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
71: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
72: BR_DISPUTED_FLAG VARCHAR2(1),
73: ATTRIBUTE_CATEGORY VARCHAR2(150),
74: ATTRIBUTE1 VARCHAR2(150),
75: ATTRIBUTE2 VARCHAR2(150),

Line 89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,

85: ATTRIBUTE12 VARCHAR2(150),
86: ATTRIBUTE13 VARCHAR2(150),
87: ATTRIBUTE14 VARCHAR2(150),
88: ATTRIBUTE15 VARCHAR2(150),
89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,

Line 90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,

86: ATTRIBUTE13 VARCHAR2(150),
87: ATTRIBUTE14 VARCHAR2(150),
88: ATTRIBUTE15 VARCHAR2(150),
89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,

Line 91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,

87: ATTRIBUTE14 VARCHAR2(150),
88: ATTRIBUTE15 VARCHAR2(150),
89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table

Line 92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,

88: ATTRIBUTE15 VARCHAR2(150),
89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

Line 93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,

89: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,

Line 94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,

90: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
91: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,

Line 96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

92: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,

Line 97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,

93: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,

Line 98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,

94: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,

Line 99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,

95: -- From auth table
96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,

Line 100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,

96: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,

Line 101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,

97: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,

Line 102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,

98: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

Line 103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,

99: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,

Line 104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,

100: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,

Line 105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,

101: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,

Line 106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

102: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,

Line 107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,

103: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,

Line 108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,

104: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,

Line 109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,

105: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

Line 110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,

106: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,

Line 111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,

107: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,

Line 112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,

108: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

Line 113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

109: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,

Line 114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,

110: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,

Line 115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,

111: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,

Line 116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

112: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,

Line 117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,

113: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

Line 118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,

114: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,

Line 119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,

115: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,

Line 120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,

116: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,

Line 121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

117: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,

Line 122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,

118: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table

Line 123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,

119: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

Line 124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,

120: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

Line 125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,

121: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
122: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
123: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
124: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
125: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
126: -- From Payers table
127: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
128: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
129: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,

Line 134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,

130: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,
131: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
132: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
133: bep_type IBY_BEPINFO.bep_type%TYPE,
134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

Line 135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,

131: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
132: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
133: bep_type IBY_BEPINFO.bep_type%TYPE,
134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),

Line 136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,

132: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
133: bep_type IBY_BEPINFO.bep_type%TYPE,
134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,

Line 137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,

133: bep_type IBY_BEPINFO.bep_type%TYPE,
134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,

Line 138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

134: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
135: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
136: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
137: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,
142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,

Line 142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,

138: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
139: int_bank_country VARCHAR2(60),
140: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
141: auth_count PLS_INTEGER,
142: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE,
143: card_subtype_code IBY_TRXN_CORE.card_subtype_code%TYPE,
144: card_data_level IBY_TRXN_CORE.card_data_level%TYPE
145: );
146:

Line 321: RETURN iby_trxn_summaries_all.tangibleid%TYPE

317: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
318: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
319: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
320: )
321: RETURN iby_trxn_summaries_all.tangibleid%TYPE
322: IS
323: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
324: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Tangible_Id';
325: BEGIN

Line 323: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

319: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
320: )
321: RETURN iby_trxn_summaries_all.tangibleid%TYPE
322: IS
323: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
324: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Tangible_Id';
325: BEGIN
326: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
327: iby_debug_pub.add('Enter with 4 params',G_LEVEL_PROCEDURE,l_dbg_mod);

Line 351: RETURN iby_trxn_summaries_all.tangibleid%TYPE

347: FUNCTION Get_Tangible_Id
348: (p_app_short_name IN fnd_application.application_short_name%TYPE,
349: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
350: )
351: RETURN iby_trxn_summaries_all.tangibleid%TYPE
352: IS
353: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
354: l_cust_pson VARCHAR2(30);
355: l_msg VARCHAR2(10);

Line 353: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

349: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
350: )
351: RETURN iby_trxn_summaries_all.tangibleid%TYPE
352: IS
353: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
354: l_cust_pson VARCHAR2(30);
355: l_msg VARCHAR2(10);
356: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Tangible_Id(2)';
357: BEGIN

Line 391: RETURN iby_trxn_summaries_all.tangibleid%TYPE

387: (
388: p_app_short_name IN fnd_application.application_short_name%TYPE,
389: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
390: )
391: RETURN iby_trxn_summaries_all.tangibleid%TYPE
392: IS
393: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
394: l_prev_pson iby_trxn_summaries_all.tangibleid%TYPE;
395: l_reauth_cnt NUMBER;

Line 393: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

389: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
390: )
391: RETURN iby_trxn_summaries_all.tangibleid%TYPE
392: IS
393: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
394: l_prev_pson iby_trxn_summaries_all.tangibleid%TYPE;
395: l_reauth_cnt NUMBER;
396: l_cust_pson VARCHAR2(30);
397: l_msg VARCHAR2(10);

Line 394: l_prev_pson iby_trxn_summaries_all.tangibleid%TYPE;

390: )
391: RETURN iby_trxn_summaries_all.tangibleid%TYPE
392: IS
393: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
394: l_prev_pson iby_trxn_summaries_all.tangibleid%TYPE;
395: l_reauth_cnt NUMBER;
396: l_cust_pson VARCHAR2(30);
397: l_msg VARCHAR2(10);
398: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Reauth_Tangible_Id';

Line 2827: l_status iby_trxn_summaries_all.status%TYPE;

2823: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
2824: l_pmt_trxn IBY_PAYMENT_ADAPTER_PUB.PmtReqTrxn_rec_type;
2825: l_riskinfo IBY_PAYMENT_ADAPTER_PUB.RiskInfo_rec_type;
2826: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
2827: l_status iby_trxn_summaries_all.status%TYPE;
2828: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
2829: l_auth_result iby_trxn_ext_auths_v.authorization_result_code%TYPE;
2830: l_pson iby_fndcpt_tx_extensions.payment_system_order_number%TYPE;
2831: l_return_status VARCHAR2(1);

Line 2828: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;

2824: l_pmt_trxn IBY_PAYMENT_ADAPTER_PUB.PmtReqTrxn_rec_type;
2825: l_riskinfo IBY_PAYMENT_ADAPTER_PUB.RiskInfo_rec_type;
2826: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
2827: l_status iby_trxn_summaries_all.status%TYPE;
2828: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
2829: l_auth_result iby_trxn_ext_auths_v.authorization_result_code%TYPE;
2830: l_pson iby_fndcpt_tx_extensions.payment_system_order_number%TYPE;
2831: l_return_status VARCHAR2(1);
2832: l_msg_count NUMBER;

Line 2899: IBY_TRXN_SUMMARIES_ALL A,

2895: x.payment_system_order_number
2896: FROM
2897: IBY_FNDCPT_TX_EXTENSIONS X,
2898: IBY_FNDCPT_TX_OPERATIONS O,
2899: IBY_TRXN_SUMMARIES_ALL A,
2900: IBY_TRXN_CORE C
2901: WHERE x.trxn_extension_id = ci_extension_id
2902: AND (x.trxn_extension_id = o.trxn_extension_id)
2903: AND (o.transactionid = a.transactionid)

Line 2923: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)

2919: AND (trxn_extension_id <> ci_trxn_x_id);
2920:
2921: CURSOR c_operation_count
2922: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2923: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
2924: IS
2925: SELECT count(1)
2926: FROM iby_fndcpt_tx_operations o
2927: WHERE o.transactionid = ci_trxn_id

Line 3259: UPDATE iby_trxn_summaries_all

3255: -- for settlement
3256: BEGIN
3257: IBY_FNDCPT_SETUP_PUB.Get_Trxn_Payer_Attributes(p_payer,p_payer_equivalency, l_payer_attribs);
3258:
3259: UPDATE iby_trxn_summaries_all
3260: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
3261: WHERE transactionid = l_reqresp.Trxn_Id;
3262:
3263: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3289: -- on the corresponding record in iby_trxn_summaries_all

3285: SET payment_system_order_number = l_tangible.Tangible_Id
3286: WHERE trxn_extension_id = p_trxn_entity_id;
3287:
3288: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3289: -- on the corresponding record in iby_trxn_summaries_all
3290: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3291: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3292: ||'on the auth record', G_LEVEL_STATEMENT,l_dbg_mod);
3293: END IF;

Line 3294: UPDATE iby_trxn_summaries_all

3290: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3291: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3292: ||'on the auth record', G_LEVEL_STATEMENT,l_dbg_mod);
3293: END IF;
3294: UPDATE iby_trxn_summaries_all
3295: SET initiator_extension_id = p_trxn_entity_id
3296: WHERE transactionid = l_reqresp.Trxn_Id
3297: AND reqtype = 'ORAPMTREQ';
3298:

Line 3851: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o

3847:
3848:
3849: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS
3850: select s.payeeid, s.org_id, s.org_type
3851: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o
3852: where s.trxntypeid = 20
3853: and s.transactionid = o.transactionid
3854: and o.trxn_extension_id = ci_trxn_extension_id;
3855:

Line 3858: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)

3854: and o.trxn_extension_id = ci_trxn_extension_id;
3855:
3856: CURSOR c_operation_count
3857: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3858: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
3859: IS
3860: SELECT count(1)
3861: FROM iby_fndcpt_tx_operations o
3862: WHERE o.transactionid = ci_trxn_id

Line 4031: -- on the corresponding record in iby_trxn_summaries_all

4027: SET payment_system_order_number = l_tangible.Tangible_Id
4028: WHERE trxn_extension_id = p_trxn_entity_id;
4029:
4030: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4031: -- on the corresponding record in iby_trxn_summaries_all
4032: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4033: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4034: ||'on the auth record', G_LEVEL_STATEMENT,l_dbg_mod);
4035: END IF;

Line 4037: UPDATE iby_trxn_summaries_all

4033: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4034: ||'on the auth record', G_LEVEL_STATEMENT,l_dbg_mod);
4035: END IF;
4036:
4037: UPDATE iby_trxn_summaries_all
4038: SET initiator_extension_id = p_trxn_entity_id
4039: WHERE transactionid = l_reqresp.Trxn_Id
4040: AND reqtype = 'ORAPMTREQ';
4041:

Line 4193: -- on the corresponding record in iby_trxn_summaries_all

4189: to_char(lx_capresp.BEPErrMessage),
4190: G_LEVEL_STATEMENT,l_dbg_mod);
4191:
4192: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4193: -- on the corresponding record in iby_trxn_summaries_all
4194: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4195: ||'on the capture record', G_LEVEL_STATEMENT,l_dbg_mod);
4196: END IF;
4197:

Line 4198: UPDATE iby_trxn_summaries_all

4194: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4195: ||'on the capture record', G_LEVEL_STATEMENT,l_dbg_mod);
4196: END IF;
4197:
4198: UPDATE iby_trxn_summaries_all
4199: SET initiator_extension_id = p_trxn_entity_id
4200: WHERE transactionid = l_reqresp.Trxn_Id
4201: AND reqtype = 'ORAPMTCAPTURE';
4202:

Line 4355: -- IBY_TRXN_SUMMARIES_ALL. This API now optionally

4351: -- Type : Public
4352: -- Pre-reqs : None
4353: -- Function : Pick up bulk settlment data from the the application
4354: -- views to insert the settlement record in
4355: -- IBY_TRXN_SUMMARIES_ALL. This API now optionally
4356: -- returns a table of reversal response
4357: --
4358: -- Current version : 1.0
4359: -- Previous version: 1.0

Line 4367: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

4363: PROCEDURE Create_Settlements (
4364: p_api_version IN NUMBER,
4365: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4366: p_calling_app_id IN NUMBER,
4367: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
4368: p_order_view_name IN VARCHAR2,
4369: x_return_status OUT NOCOPY VARCHAR2,
4370: x_msg_count OUT NOCOPY NUMBER,
4371: x_msg_data OUT NOCOPY VARCHAR2,

Line 4385: TYPE TrxnTabType IS TABLE OF IBY_TRXN_SUMMARIES_ALL%ROWTYPE

4381:
4382: --
4383: -- This record are used to insert into the funds capture orders
4384: --
4385: TYPE TrxnTabType IS TABLE OF IBY_TRXN_SUMMARIES_ALL%ROWTYPE
4386: INDEX BY BINARY_INTEGER;
4387:
4388: l_Trxn_Tab TrxnTabType;
4389: empty_Trxn_Tab TrxnTabType;

Line 4441: -- in the iby_trxn_summaries_all table.

4437: tangibleIndx PLS_INTEGER := 0;
4438:
4439: -- Bug# 7658675.REMITTANCE BATCH (IBY_FNDCPT_TRXN_PUB.CREATE_SETTLEMENTS) LTD TO 1000 RECORDS
4440: -- new variables defined for inserting all the remitted records
4441: -- in the iby_trxn_summaries_all table.
4442: -- variable l is used to initialize the record# in the inner loop.
4443: -- rec_limit is the no of fecords processed in each fetch(iteration).It is
4444: -- initialized to 1000 as per design.
4445:

Line 4456: l_debit_auth_id iby_trxn_summaries_all.debit_authorization_id%TYPE;

4452: lx_process_profile iby_fndcpt_user_cc_pf_b.USER_CC_PROFILE_CODE %TYPE;
4453: lx_bep_key iby_bepkeys.key%TYPE;
4454: l_routing_failure BOOLEAN;
4455: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || 'Create_Settlements(2)';
4456: l_debit_auth_id iby_trxn_summaries_all.debit_authorization_id%TYPE;
4457: l_payment_type_code VARCHAR2(10);
4458: l_mandate_trxn_count NUMBER(10);
4459:
4460: /* For reversal */

Line 4473: CURSOR c_auth (c_tid IBY_TRXN_SUMMARIES_ALL.TRANSACTIONID%TYPE) IS

4469: l_interface_code iby_result_codes.request_interface_code%TYPE;
4470: l_cap_ex_auth_bep VARCHAR2(1) := 'Y';
4471: l_cap_ex_auth_issuer VARCHAR2(1) := 'Y';
4472:
4473: CURSOR c_auth (c_tid IBY_TRXN_SUMMARIES_ALL.TRANSACTIONID%TYPE) IS
4474: SELECT CORE.authcode
4475: FROM IBY_TRXN_SUMMARIES_ALL TX,
4476: IBY_TRXN_CORE CORE
4477: WHERE TX.TRANSACTIONID = c_tid

Line 4475: FROM IBY_TRXN_SUMMARIES_ALL TX,

4471: l_cap_ex_auth_issuer VARCHAR2(1) := 'Y';
4472:
4473: CURSOR c_auth (c_tid IBY_TRXN_SUMMARIES_ALL.TRANSACTIONID%TYPE) IS
4474: SELECT CORE.authcode
4475: FROM IBY_TRXN_SUMMARIES_ALL TX,
4476: IBY_TRXN_CORE CORE
4477: WHERE TX.TRANSACTIONID = c_tid
4478: AND TX.TRXNMID=CORE.TRXNMID
4479: AND TX.TRXNTYPEID=2

Line 4789: IBY_TRXN_SUMMARIES_ALL auth,

4785: auth_trxn_core.card_data_level card_data_level
4786: FROM '||l_view_name||' orders,
4787: IBY_FNDCPT_TX_EXTENSIONS trxnext,
4788: IBY_EXTERNAL_PAYERS_ALL payer,
4789: IBY_TRXN_SUMMARIES_ALL auth,
4790: IBY_FNDCPT_TX_OPERATIONS trxnop,
4791: IBY_TRXN_SUMMARIES_ALL captures,
4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,
4793: IBY_BEPINFO bep,

Line 4791: IBY_TRXN_SUMMARIES_ALL captures,

4787: IBY_FNDCPT_TX_EXTENSIONS trxnext,
4788: IBY_EXTERNAL_PAYERS_ALL payer,
4789: IBY_TRXN_SUMMARIES_ALL auth,
4790: IBY_FNDCPT_TX_OPERATIONS trxnop,
4791: IBY_TRXN_SUMMARIES_ALL captures,
4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,
4793: IBY_BEPINFO bep,
4794: IBY_FNDCPT_USER_EFT_PF_B eft_user,
4795: IBY_FNDCPT_SYS_EFT_PF_B eft_sys,

Line 4891: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;

4887: l_settlement_trxn_rec.TRXNMID);
4888:
4889: DECLARE
4890: lx_payeeid iby_payee.payeeid%TYPE;
4891: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4892: lx_pmt_name VARCHAR2(100);
4893: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4894: lx_payee_user_name iby_payee.username%TYPE;
4895: lx_payee_passwd iby_payee.password%TYPE;

Line 5340: from iby_trxn_summaries_all summ

5336: l_Trxn_Tab(indx).seq_type := l_payment_type_code;
5337: ELSE
5338:
5339: select count(*) into l_mandate_trxn_count
5340: from iby_trxn_summaries_all summ
5341: ,iby_fndcpt_tx_extensions ext
5342: ,iby_fndcpt_tx_operations op
5343: where summ.transactionid = op.transactionid
5344: and op.trxn_extension_id = ext.trxn_extension_id

Line 5353: from iby_trxn_summaries_all

5349: l_Trxn_Tab(indx).seq_type := 'FNAL';
5350: ELSE
5351:
5352: select count(*) into l_mandate_trxn_count
5353: from iby_trxn_summaries_all
5354: where trxntypeid = 100
5355: and instrtype = 'BANKACCOUNT'
5356: and debit_authorization_id = l_debit_auth_id
5357: and status in (100,0,111);

Line 5380: -- on the corresponding record in iby_trxn_summaries_all

5376: l_Trxn_Tab(indx).debit_auth_reference := l_settlement_trxn_rec.debit_auth_reference;
5377: l_Trxn_Tab(indx).dirdeb_instruction_code := l_settlement_trxn_rec.auth_dirdeb_instruction_code;
5378:
5379: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
5380: -- on the corresponding record in iby_trxn_summaries_all
5381: l_Trxn_Tab(indx).initiator_extension_id := l_settlement_trxn_rec.PAYMENT_TRXN_EXTENSION_ID;
5382:
5383: /*
5384: * Fix for bug 5614670:

Line 5439: -- Bulk Insert settlement records in IBY_TRXN_SUMMARIES_ALL

5435:
5436: END LOOP; -- Settlement transaction loop
5437:
5438: --
5439: -- Bulk Insert settlement records in IBY_TRXN_SUMMARIES_ALL
5440: --
5441: --
5442: print_debuginfo(l_module_name, 'Inserting ' || l_Trxn_Tab.count ||
5443: ' transactions');

Line 5446: -- insert into IBY_TRXN_SUMMARIES_ALL

5442: print_debuginfo(l_module_name, 'Inserting ' || l_Trxn_Tab.count ||
5443: ' transactions');
5444:
5445: IF (l_Trxn_Tab.COUNT > 0) THEN
5446: -- insert into IBY_TRXN_SUMMARIES_ALL
5447: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
5448: INSERT INTO IBY_TRXN_SUMMARIES_ALL VALUES l_Trxn_Tab(j);
5449: END IF;
5450:

Line 5448: INSERT INTO IBY_TRXN_SUMMARIES_ALL VALUES l_Trxn_Tab(j);

5444:
5445: IF (l_Trxn_Tab.COUNT > 0) THEN
5446: -- insert into IBY_TRXN_SUMMARIES_ALL
5447: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
5448: INSERT INTO IBY_TRXN_SUMMARIES_ALL VALUES l_Trxn_Tab(j);
5449: END IF;
5450:
5451: print_debuginfo(l_module_name, 'Inserted ' || SQL%ROWCOUNT
5452: || ' transactions');

Line 5563: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

5559: PROCEDURE Create_Settlements (
5560: p_api_version IN NUMBER,
5561: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5562: p_calling_app_id IN NUMBER,
5563: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
5564: p_order_view_name IN VARCHAR2,
5565: x_return_status OUT NOCOPY VARCHAR2,
5566: x_msg_count OUT NOCOPY NUMBER,
5567: x_msg_data OUT NOCOPY VARCHAR2,

Line 5830: -- on the corresponding record in iby_trxn_summaries_all

5826: SET payment_system_order_number = l_tangible.Tangible_Id
5827: WHERE trxn_extension_id = p_trxn_entity_id;
5828:
5829: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
5830: -- on the corresponding record in iby_trxn_summaries_all
5831: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5832: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
5833: ||'on the credit record', G_LEVEL_STATEMENT,G_DEBUG_MODULE || l_module);
5834: END IF;

Line 5835: UPDATE iby_trxn_summaries_all

5831: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5832: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
5833: ||'on the credit record', G_LEVEL_STATEMENT,G_DEBUG_MODULE || l_module);
5834: END IF;
5835: UPDATE iby_trxn_summaries_all
5836: SET initiator_extension_id = p_trxn_entity_id
5837: WHERE transactionid = lx_creditresp.Trxn_Id
5838: AND reqtype = 'ORAPMTCREDIT';
5839:

Line 5880: -- on the corresponding record in iby_trxn_summaries_all

5876: SET payment_system_order_number = l_return_pson
5877: WHERE trxn_extension_id = p_trxn_entity_id;
5878:
5879: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
5880: -- on the corresponding record in iby_trxn_summaries_all
5881: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5882: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
5883: ||'on the return record', G_LEVEL_STATEMENT,G_DEBUG_MODULE || l_module);
5884: END IF;

Line 5885: UPDATE iby_trxn_summaries_all

5881: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5882: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
5883: ||'on the return record', G_LEVEL_STATEMENT,G_DEBUG_MODULE || l_module);
5884: END IF;
5885: UPDATE iby_trxn_summaries_all
5886: SET initiator_extension_id = p_trxn_entity_id
5887: WHERE transactionid = lx_returnresp.Trxn_Id
5888: AND reqtype = 'ORAPMTRETURN';
5889:

Line 6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;

6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6066: l_app_short_name fnd_application.application_short_name%TYPE;
6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;
6072: l_bep_auth_rev VARCHAR2(1);

Line 6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;

6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;
6066: l_app_short_name fnd_application.application_short_name%TYPE;
6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;
6072: l_bep_auth_rev VARCHAR2(1);
6073: l_card_auth_rev VARCHAR2(1);

Line 6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;

6066: l_app_short_name fnd_application.application_short_name%TYPE;
6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;
6072: l_bep_auth_rev VARCHAR2(1);
6073: l_card_auth_rev VARCHAR2(1);
6074: l_pson IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE;

Line 6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;

6067: l_pmt_chnl_code IBY_FNDCPT_PMT_CHNNLS_B.payment_channel_code%TYPE;
6068: l_trxn_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE;
6069: l_auth_status IBY_TRXN_SUMMARIES_ALL.status%TYPE;
6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;
6072: l_bep_auth_rev VARCHAR2(1);
6073: l_card_auth_rev VARCHAR2(1);
6074: l_pson IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE;
6075: l_settled VARCHAR2(1);

Line 6074: l_pson IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE;

6070: l_auth_amt IBY_TRXN_SUMMARIES_ALL.amount%TYPE;
6071: l_auth_curr IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE;
6072: l_bep_auth_rev VARCHAR2(1);
6073: l_card_auth_rev VARCHAR2(1);
6074: l_pson IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE;
6075: l_settled VARCHAR2(1);
6076: l_ecapp_id NUMBER;
6077: l_rev_trxn IBY_PAYMENT_ADAPTER_PUB.RevTrxn_rec_type;
6078: l_pmt_trxn IBY_PAYMENT_ADAPTER_PUB.PmtReqTrxn_rec_type;

Line 6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;

6083: l_payee IBY_PAYMENT_ADAPTER_PUB.Payee_rec_type;
6084: l_payer IBY_PAYMENT_ADAPTER_PUB.Payer_rec_type;
6085: l_tangible IBY_PAYMENT_ADAPTER_PUB.Tangible_rec_type;
6086: l_pmt_instr IBY_PAYMENT_ADAPTER_PUB.PmtInstr_rec_type;
6087: l_org_id IBY_TRXN_SUMMARIES_ALL.org_id%TYPE;
6088: l_authcode IBY_TRXN_CORE.authcode%TYPE;
6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;

Line 6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;

6089: l_tracenumber IBY_TRXN_CORE.tracenumber%TYPE;
6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;
6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;
6095: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
6096:
6097: lx_rev_resp IBY_PAYMENT_ADAPTER_PUB.RevResp_rec_type;

Line 6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;

6090: l_tax_amt IBY_TRXN_CORE.taxamount%TYPE;
6091: l_ship_from_zip IBY_TRXN_CORE.shipfromzip%TYPE;
6092: l_ship_to_zip IBY_TRXN_CORE.shiptozip%TYPE;
6093: l_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE;
6094: l_rcpt_method_id IBY_TRXN_SUMMARIES_ALL.ar_receipt_method_id%TYPE;
6095: l_reqresp IBY_PAYMENT_ADAPTER_PUB.ReqResp_rec_type;
6096:
6097: lx_rev_resp IBY_PAYMENT_ADAPTER_PUB.RevResp_rec_type;
6098:

Line 6147: iby_trxn_summaries_all auth,

6143: core.taxamount, core.shipfromzip, core.shiptozip,
6144: auth.factored_flag, auth.ar_receipt_method_id
6145: FROM iby_fndcpt_tx_extensions xt,
6146: iby_fndcpt_tx_operations op,
6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand

Line 6163: (ci_transactionid IN iby_trxn_summaries_all.transactionid%TYPE)

6159: AND (auth.bepid = bep.bepid)
6160: AND (auth.instrsubtype = brand.card_issuer_code);
6161:
6162: CURSOR c_settlement
6163: (ci_transactionid IN iby_trxn_summaries_all.transactionid%TYPE)
6164: IS
6165: SELECT 1 FROM iby_trxn_summaries_all
6166: WHERE transactionid = ci_transactionid
6167: AND reqtype = 'ORAPMTCAPTURE'

Line 6165: SELECT 1 FROM iby_trxn_summaries_all

6161:
6162: CURSOR c_settlement
6163: (ci_transactionid IN iby_trxn_summaries_all.transactionid%TYPE)
6164: IS
6165: SELECT 1 FROM iby_trxn_summaries_all
6166: WHERE transactionid = ci_transactionid
6167: AND reqtype = 'ORAPMTCAPTURE'
6168: AND status IN (0,100,111,11);
6169:

Line 6439: UPDATE iby_trxn_summaries_all

6435: UPDATE iby_fndcpt_tx_extensions
6436: SET payment_system_order_number = l_tangible.Tangible_Id
6437: WHERE trxn_extension_id = p_trxn_entity_id;
6438:
6439: UPDATE iby_trxn_summaries_all
6440: SET initiator_extension_id = p_trxn_entity_id
6441: WHERE transactionid = l_reqresp.Trxn_Id
6442: AND reqtype = 'ORAPMTREQ'
6443: AND initiator_extension_id IS NULL;

Line 6962: l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)

6958: | NOTES:
6959: |
6960: *---------------------------------------------------------------------*/
6961: FUNCTION get_le_from_bankacct_id(
6962: l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)
6963: RETURN NUMBER
6964: IS
6965:
6966: l_le_id NUMBER;