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.

[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,

25: -------------------------------------------------------------------------
26:
27:
28: TYPE FuncCaptureOrder_rec_type IS RECORD (
29: TRXNMID IBY_TRXN_SUMMARIES_ALL.TRXNMID%TYPE,
30: -- From IBY_FNDCPT_TX_EXTENSIONS
31: TRXN_REF_NUMBER1 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER1%TYPE,
32: TRXN_REF_NUMBER2 IBY_FNDCPT_TX_EXTENSIONS.TRXN_REF_NUMBER2%TYPE,
33: PAYMENT_CHANNEL_CODE IBY_FNDCPT_TX_EXTENSIONS.PAYMENT_CHANNEL_CODE%TYPE,

Line 38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

34: PO_NUMBER IBY_FNDCPT_TX_EXTENSIONS.PO_NUMBER%TYPE,
35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,

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

35: VOICE_AUTHORIZATION_FLAG IBY_FNDCPT_TX_EXTENSIONS.VOICE_AUTHORIZATION_FLAG%TYPE,
36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),

Line 40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,

36: PAYMENT_FUNCTION IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,

Line 41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,

37: -- From the ORDERS View
38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,

Line 42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,

38: CALL_APP_SERVICE_REQ_CODE IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
39: --CALLING_APP_DOC_REF_NUMBER IBY_TRXN_SUMMARIES_ALL.CALLING_APP_DOC_REF_NUMBER%TYPE,
40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,

Line 44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,

40: SETTLEMENT_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEDATE%TYPE,
41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

Line 45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,

41: SETTLEMENT_DUE_DATE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_DUE_DATE%TYPE,
42: BR_MATURITY_DATE IBY_TRXN_SUMMARIES_ALL.BR_MATURITY_DATE%TYPE,
43: ORDER_DESCRIPTION VARCHAR2(255),
44: SETTLEMENT_CURRENCY_CODE IBY_TRXN_SUMMARIES_ALL.CURRENCYNAMECODE%TYPE,
45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,

Line 49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,

45: SETTLEMENT_AMOUNT IBY_TRXN_SUMMARIES_ALL.AMOUNT%TYPE,
46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,

Line 50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,

46: PAYMENT_TRXN_EXTENSION_ID IBY_FNDCPT_TX_EXTENSIONS.TRXN_EXTENSION_ID%TYPE,
47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,

Line 51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,

47: INTERNAL_BANK_ACCOUNT_ID CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,

Line 52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,

48: PAYER_PARTY_ID IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,

Line 53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,

49: CUST_ACCOUNT_ID IBY_TRXN_SUMMARIES_ALL.CUST_ACCOUNT_ID%TYPE,
50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,

Line 54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,

50: ACCT_SITE_USE_ID IBY_TRXN_SUMMARIES_ALL.ACCT_SITE_USE_ID%TYPE,
51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,

Line 55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,

51: ORG_ID IBY_TRXN_SUMMARIES_ALL.ORG_ID%TYPE,
52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
59: BR_DISPUTED_FLAG VARCHAR2(1),

Line 56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,

52: ORG_TYPE IBY_TRXN_SUMMARIES_ALL.ORG_TYPE%TYPE,
53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
59: BR_DISPUTED_FLAG VARCHAR2(1),
60: ATTRIBUTE_CATEGORY VARCHAR2(150),

Line 57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,

53: LEGAL_ENTITY_ID IBY_TRXN_SUMMARIES_ALL.LEGAL_ENTITY_ID%TYPE,
54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
59: BR_DISPUTED_FLAG VARCHAR2(1),
60: ATTRIBUTE_CATEGORY VARCHAR2(150),
61: ATTRIBUTE1 VARCHAR2(150),

Line 58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,

54: BILL_TO_ADDRESS_ID IBY_TRXN_SUMMARIES_ALL.BILL_TO_ADDRESS_ID%TYPE,
55: SETTLEMENT_CUSTOMER_REFERENCE IBY_TRXN_SUMMARIES_ALL.SETTLEMENT_CUSTOMER_REFERENCE%TYPE,
56: AR_RECEIPT_METHOD_ID IBY_TRXN_SUMMARIES_ALL.AR_RECEIPT_METHOD_ID%TYPE,
57: BR_DRAWEE_ISSUED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_DRAWEE_ISSUED_FLAG%TYPE,
58: BR_SIGNED_FLAG IBY_TRXN_SUMMARIES_ALL.BR_SIGNED_FLAG%TYPE,
59: BR_DISPUTED_FLAG VARCHAR2(1),
60: ATTRIBUTE_CATEGORY VARCHAR2(150),
61: ATTRIBUTE1 VARCHAR2(150),
62: ATTRIBUTE2 VARCHAR2(150),

Line 76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,

72: ATTRIBUTE12 VARCHAR2(150),
73: ATTRIBUTE13 VARCHAR2(150),
74: ATTRIBUTE14 VARCHAR2(150),
75: ATTRIBUTE15 VARCHAR2(150),
76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,

Line 77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,

73: ATTRIBUTE13 VARCHAR2(150),
74: ATTRIBUTE14 VARCHAR2(150),
75: ATTRIBUTE15 VARCHAR2(150),
76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,

Line 78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,

74: ATTRIBUTE14 VARCHAR2(150),
75: ATTRIBUTE15 VARCHAR2(150),
76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table

Line 79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,

75: ATTRIBUTE15 VARCHAR2(150),
76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

Line 80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,

76: CREATED_BY IBY_TRXN_SUMMARIES_ALL.CREATED_BY%TYPE,
77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,

Line 81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,

77: CREATION_DATE IBY_TRXN_SUMMARIES_ALL.CREATION_DATE%TYPE,
78: LAST_UPDATED_BY IBY_TRXN_SUMMARIES_ALL.LAST_UPDATED_BY%TYPE,
79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,

Line 83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

79: LAST_UPDATE_DATE IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_DATE%TYPE,
80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,

Line 84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,

80: LAST_UPDATE_LOGIN IBY_TRXN_SUMMARIES_ALL.LAST_UPDATE_LOGIN%TYPE,
81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,

Line 85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,

81: OBJECT_VERSION_NUMBER IBY_TRXN_SUMMARIES_ALL.OBJECT_VERSION_NUMBER%TYPE,
82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,

Line 86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,

82: -- From auth table
83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,

Line 87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,

83: auth_transactionid IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,

Line 88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,

84: auth_sales_rep_party_id IBY_TRXN_SUMMARIES_ALL.sales_rep_party_id%TYPE,
85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,

Line 89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,

85: auth_tangibleid IBY_TRXN_SUMMARIES_ALL.tangibleid%TYPE,
86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

Line 90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,

86: auth_bepkey IBY_TRXN_SUMMARIES_ALL.bepkey%TYPE,
87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,

Line 91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,

87: auth_payeeid IBY_TRXN_SUMMARIES_ALL.payeeid%TYPE,
88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,

Line 92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,

88: auth_bepid IBY_TRXN_SUMMARIES_ALL.bepid%TYPE,
89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,

Line 93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,

89: auth_mpayeeid IBY_TRXN_SUMMARIES_ALL.mpayeeid%TYPE,
90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,

Line 94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,

90: auth_ecappid IBY_TRXN_SUMMARIES_ALL.ecappid%TYPE,
91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,

Line 95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,

91: auth_paymentmethodname IBY_TRXN_SUMMARIES_ALL.paymentmethodname%TYPE,
92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,

Line 96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,

92: auth_mtangibleid IBY_TRXN_SUMMARIES_ALL.mtangibleid%TYPE,
93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

Line 97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,

93: auth_payeeinstrid IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE,
94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,

Line 98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,

94: auth_payerid IBY_TRXN_SUMMARIES_ALL.payerid%TYPE,
95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,

Line 99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,

95: auth_payerinstrid IBY_TRXN_SUMMARIES_ALL.payerinstrid%TYPE,
96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

Line 100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,

96: auth_detaillookup IBY_TRXN_SUMMARIES_ALL.detaillookup%TYPE,
97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,

Line 101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,

97: auth_instrnumber IBY_TRXN_SUMMARIES_ALL.instrnumber%TYPE,
98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,

Line 102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,

98: auth_instrtype IBY_TRXN_SUMMARIES_ALL.instrtype%TYPE,
99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,

Line 103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,

99: auth_instrsubtype IBY_TRXN_SUMMARIES_ALL.instrsubtype%TYPE,
100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,

Line 104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,

100: auth_currencynamecode IBY_TRXN_SUMMARIES_ALL.currencynamecode%TYPE,
101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

Line 105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,

101: auth_desturl IBY_TRXN_SUMMARIES_ALL.desturl%TYPE,
102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,

Line 106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,

102: auth_nlslang IBY_TRXN_SUMMARIES_ALL.nlslang%TYPE,
103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,

Line 107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,

103: auth_amount IBY_TRXN_SUMMARIES_ALL.amount%TYPE,
104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,

Line 108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,

104: auth_process_profile_code IBY_TRXN_SUMMARIES_ALL.process_profile_code%TYPE,
105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,

Line 109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,

105: auth_payment_channel_code IBY_TRXN_SUMMARIES_ALL.payment_channel_code%TYPE,
106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table

Line 110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,

106: auth_proc_reference_code IBY_TRXN_SUMMARIES_ALL.proc_reference_code%TYPE,
107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,

Line 111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,

107: auth_proc_reference_amount IBY_TRXN_SUMMARIES_ALL.proc_reference_amount%TYPE,
108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,

Line 112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,

108: auth_legal_entity_id IBY_TRXN_SUMMARIES_ALL.legal_entity_id%TYPE,
109: auth_settlement_due_date IBY_TRXN_SUMMARIES_ALL.settlement_due_date%TYPE,
110: auth_bill_to_address_id IBY_TRXN_SUMMARIES_ALL.bill_to_address_id%TYPE,
111: auth_br_maturity_date IBY_TRXN_SUMMARIES_ALL.br_maturity_date%TYPE,
112: auth_factored_flag IBY_TRXN_SUMMARIES_ALL.factored_flag%TYPE,
113: -- From Payers table
114: auth_payment_function IBY_EXTERNAL_PAYERS_ALL.PAYMENT_FUNCTION%TYPE,
115: auth_payer_party_id IBY_EXTERNAL_PAYERS_ALL.PARTY_ID%TYPE,
116: auth_cust_account_id IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID%TYPE,

Line 121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,

117: auth_acct_site_use_id IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID%TYPE,
118: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
119: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
120: bep_type IBY_BEPINFO.bep_type%TYPE,
121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

Line 122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,

118: auth_org_id IBY_EXTERNAL_PAYERS_ALL.ORG_ID%TYPE,
119: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
120: bep_type IBY_BEPINFO.bep_type%TYPE,
121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: int_bank_country VARCHAR2(60),

Line 123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,

119: auth_org_type IBY_EXTERNAL_PAYERS_ALL.ORG_TYPE%TYPE,
120: bep_type IBY_BEPINFO.bep_type%TYPE,
121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: int_bank_country VARCHAR2(60),
127: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,

Line 124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,

120: bep_type IBY_BEPINFO.bep_type%TYPE,
121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: int_bank_country VARCHAR2(60),
127: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
128: auth_count PLS_INTEGER,

Line 125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,

121: payer_instr_assignment_id IBY_TRXN_SUMMARIES_ALL.payer_instr_assignment_id%TYPE,
122: debit_auth_flag IBY_TRXN_SUMMARIES_ALL.debit_auth_flag%TYPE,
123: debit_auth_method IBY_TRXN_SUMMARIES_ALL.debit_auth_method%TYPE,
124: debit_auth_reference IBY_TRXN_SUMMARIES_ALL.debit_auth_reference%TYPE,
125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: int_bank_country VARCHAR2(60),
127: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
128: auth_count PLS_INTEGER,
129: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE

Line 129: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE

125: capture_transaction_id IBY_TRXN_SUMMARIES_ALL.transactionid%TYPE,
126: int_bank_country VARCHAR2(60),
127: settle_req_vrfy IBY_FNDCPT_SYS_EFT_PF_B.SETTLE_REQUIRE_VRFY_FLAG%TYPE,
128: auth_count PLS_INTEGER,
129: auth_dirdeb_instruction_code IBY_TRXN_SUMMARIES_ALL.dirdeb_instruction_code%TYPE
130: );
131:
132: -- II.2 Table Types
133:

Line 271: RETURN iby_trxn_summaries_all.tangibleid%TYPE

267: p_order_id IN iby_fndcpt_tx_extensions.order_id%TYPE,
268: p_trxn_ref1 IN iby_fndcpt_tx_extensions.trxn_ref_number1%TYPE,
269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )
271: RETURN iby_trxn_summaries_all.tangibleid%TYPE
272: IS
273: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
274: BEGIN
275: l_tangible_id := p_app_short_name || '_' || p_order_id;

Line 273: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

269: p_trxn_ref2 IN iby_fndcpt_tx_extensions.trxn_ref_number2%TYPE
270: )
271: RETURN iby_trxn_summaries_all.tangibleid%TYPE
272: IS
273: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
274: BEGIN
275: l_tangible_id := p_app_short_name || '_' || p_order_id;
276:
277: IF (NOT p_trxn_ref1 IS NULL) THEN

Line 292: RETURN iby_trxn_summaries_all.tangibleid%TYPE

288: FUNCTION Get_Tangible_Id
289: (p_app_short_name IN fnd_application.application_short_name%TYPE,
290: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
291: )
292: RETURN iby_trxn_summaries_all.tangibleid%TYPE
293: IS
294: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
295: BEGIN
296: l_tangible_id := p_app_short_name || '_' || p_trxn_extn_id;

Line 294: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;

290: p_trxn_extn_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE
291: )
292: RETURN iby_trxn_summaries_all.tangibleid%TYPE
293: IS
294: l_tangible_id iby_trxn_summaries_all.tangibleid%TYPE;
295: BEGIN
296: l_tangible_id := p_app_short_name || '_' || p_trxn_extn_id;
297: RETURN l_tangible_id;
298: END Get_Tangible_Id;

Line 2381: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)

2377: AND (trxn_extension_id <> ci_trxn_x_id);
2378:
2379: CURSOR c_operation_count
2380: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2381: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
2382: IS
2383: SELECT count(1)
2384: FROM iby_fndcpt_tx_operations o
2385: WHERE o.transactionid = ci_trxn_id

Line 2605: UPDATE iby_trxn_summaries_all

2601: -- for settlement
2602: BEGIN
2603: IBY_FNDCPT_SETUP_PUB.Get_Trxn_Payer_Attributes(p_payer,p_payer_equivalency, l_payer_attribs);
2604:
2605: UPDATE iby_trxn_summaries_all
2606: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
2607: WHERE transactionid = l_reqresp.Trxn_Id;
2608:
2609: iby_debug_pub.add('Set DirectDebit_BankInstruction for trxn',

Line 2630: -- on the corresponding record in iby_trxn_summaries_all

2626: SET payment_system_order_number = l_tangible.Tangible_Id
2627: WHERE trxn_extension_id = p_trxn_entity_id;
2628:
2629: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
2630: -- on the corresponding record in iby_trxn_summaries_all
2631: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
2632: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2633:
2634: UPDATE iby_trxn_summaries_all

Line 2634: UPDATE iby_trxn_summaries_all

2630: -- on the corresponding record in iby_trxn_summaries_all
2631: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
2632: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2633:
2634: UPDATE iby_trxn_summaries_all
2635: SET initiator_extension_id = p_trxn_entity_id
2636: WHERE transactionid = l_reqresp.Trxn_Id
2637: AND reqtype = 'ORAPMTREQ';
2638:

Line 3100: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o

3096:
3097:
3098: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS
3099: select s.payeeid, s.org_id, s.org_type
3100: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o
3101: where s.trxntypeid = 20
3102: and s.transactionid = o.transactionid
3103: and o.trxn_extension_id = ci_trxn_extension_id;
3104:

Line 3107: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)

3103: and o.trxn_extension_id = ci_trxn_extension_id;
3104:
3105: CURSOR c_operation_count
3106: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3107: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
3108: IS
3109: SELECT count(1)
3110: FROM iby_fndcpt_tx_operations o
3111: WHERE o.transactionid = ci_trxn_id

Line 3267: -- on the corresponding record in iby_trxn_summaries_all

3263: SET payment_system_order_number = l_tangible.Tangible_Id
3264: WHERE trxn_extension_id = p_trxn_entity_id;
3265:
3266: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3267: -- on the corresponding record in iby_trxn_summaries_all
3268: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3269: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3270:
3271: UPDATE iby_trxn_summaries_all

Line 3271: UPDATE iby_trxn_summaries_all

3267: -- on the corresponding record in iby_trxn_summaries_all
3268: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3269: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3270:
3271: UPDATE iby_trxn_summaries_all
3272: SET initiator_extension_id = p_trxn_entity_id
3273: WHERE transactionid = l_reqresp.Trxn_Id
3274: AND reqtype = 'ORAPMTREQ';
3275:

Line 3419: -- on the corresponding record in iby_trxn_summaries_all

3415: to_char(lx_capresp.BEPErrMessage),
3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3417:
3418: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3419: -- on the corresponding record in iby_trxn_summaries_all
3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3421: ||'on the capture record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3422:
3423: UPDATE iby_trxn_summaries_all

Line 3423: UPDATE iby_trxn_summaries_all

3419: -- on the corresponding record in iby_trxn_summaries_all
3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3421: ||'on the capture record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3422:
3423: UPDATE iby_trxn_summaries_all
3424: SET initiator_extension_id = p_trxn_entity_id
3425: WHERE transactionid = l_reqresp.Trxn_Id
3426: AND reqtype = 'ORAPMTCAPTURE';
3427:

Line 3563: -- IBY_TRXN_SUMMARIES_ALL

3559: -- Type : Public
3560: -- Pre-reqs : None
3561: -- Function : Pick up bulk settlment data from the the application
3562: -- views to insert the settlement record in
3563: -- IBY_TRXN_SUMMARIES_ALL
3564: -- Current version : 1.0
3565: -- Previous version: 1.0
3566: -- Initial version : 1.0
3567: --

Line 3573: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,

3569: PROCEDURE Create_Settlements (
3570: p_api_version IN NUMBER,
3571: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3572: p_calling_app_id IN NUMBER,
3573: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
3574: p_order_view_name IN VARCHAR2,
3575: x_return_status OUT NOCOPY VARCHAR2,
3576: x_msg_count OUT NOCOPY NUMBER,
3577: x_msg_data OUT NOCOPY VARCHAR2,

Line 3590: TYPE TrxnTabType IS TABLE OF IBY_TRXN_SUMMARIES_ALL%ROWTYPE

3586:
3587: --
3588: -- This record are used to insert into the funds capture orders
3589: --
3590: TYPE TrxnTabType IS TABLE OF IBY_TRXN_SUMMARIES_ALL%ROWTYPE
3591: INDEX BY BINARY_INTEGER;
3592:
3593: l_Trxn_Tab TrxnTabType;
3594: empty_Trxn_Tab TrxnTabType;

Line 3646: -- in the iby_trxn_summaries_all table.

3642: tangibleIndx PLS_INTEGER := 0;
3643:
3644: -- Bug# 7658675.REMITTANCE BATCH (IBY_FNDCPT_TRXN_PUB.CREATE_SETTLEMENTS) LTD TO 1000 RECORDS
3645: -- new variables defined for inserting all the remitted records
3646: -- in the iby_trxn_summaries_all table.
3647: -- variable l is used to initialize the record# in the inner loop.
3648: -- rec_limit is the no of fecords processed in each fetch(iteration).It is
3649: -- initialized to 1000 as per design.
3650:

Line 3952: IBY_TRXN_SUMMARIES_ALL auth,

3948: auth.dirdeb_instruction_code auth_dirdeb_instruction_code
3949: FROM '||l_view_name||' orders,
3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,
3951: IBY_EXTERNAL_PAYERS_ALL payer,
3952: IBY_TRXN_SUMMARIES_ALL auth,
3953: IBY_FNDCPT_TX_OPERATIONS trxnop,
3954: IBY_TRXN_SUMMARIES_ALL captures,
3955: IBY_EXTERNAL_PAYERS_ALL auth_payer,
3956: IBY_BEPINFO bep,

Line 3954: IBY_TRXN_SUMMARIES_ALL captures,

3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,
3951: IBY_EXTERNAL_PAYERS_ALL payer,
3952: IBY_TRXN_SUMMARIES_ALL auth,
3953: IBY_FNDCPT_TX_OPERATIONS trxnop,
3954: IBY_TRXN_SUMMARIES_ALL captures,
3955: IBY_EXTERNAL_PAYERS_ALL auth_payer,
3956: IBY_BEPINFO bep,
3957: IBY_FNDCPT_USER_EFT_PF_B eft_user,
3958: IBY_FNDCPT_SYS_EFT_PF_B eft_sys,

Line 4049: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;

4045: l_settlement_trxn_rec.TRXNMID);
4046:
4047: DECLARE
4048: lx_payeeid iby_payee.payeeid%TYPE;
4049: lx_order_id iby_trxn_summaries_all.tangibleid%TYPE;
4050: lx_pmt_name VARCHAR2(100);
4051: lx_bep_lang iby_bepinfo.nls_language%TYPE;
4052: lx_payee_user_name iby_payee.username%TYPE;
4053: lx_payee_passwd iby_payee.password%TYPE;

Line 4356: -- on the corresponding record in iby_trxn_summaries_all

4352: l_Trxn_Tab(indx).debit_auth_reference := l_settlement_trxn_rec.debit_auth_reference;
4353: l_Trxn_Tab(indx).dirdeb_instruction_code := l_settlement_trxn_rec.auth_dirdeb_instruction_code;
4354:
4355: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4356: -- on the corresponding record in iby_trxn_summaries_all
4357: l_Trxn_Tab(indx).initiator_extension_id := l_settlement_trxn_rec.PAYMENT_TRXN_EXTENSION_ID;
4358:
4359: /*
4360: * Fix for bug 5614670:

Line 4413: -- Bulk Insert settlement records in IBY_TRXN_SUMMARIES_ALL

4409:
4410: END LOOP; -- Settlement transaction loop
4411:
4412: --
4413: -- Bulk Insert settlement records in IBY_TRXN_SUMMARIES_ALL
4414: --
4415: --
4416: print_debuginfo(l_module_name, 'Inserting ' || l_Trxn_Tab.count ||
4417: ' transactions');

Line 4420: -- insert into IBY_TRXN_SUMMARIES_ALL

4416: print_debuginfo(l_module_name, 'Inserting ' || l_Trxn_Tab.count ||
4417: ' transactions');
4418:
4419: IF (l_Trxn_Tab.COUNT > 0) THEN
4420: -- insert into IBY_TRXN_SUMMARIES_ALL
4421: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
4422: INSERT INTO IBY_TRXN_SUMMARIES_ALL VALUES l_Trxn_Tab(j);
4423: END IF;
4424:

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

4418:
4419: IF (l_Trxn_Tab.COUNT > 0) THEN
4420: -- insert into IBY_TRXN_SUMMARIES_ALL
4421: FORALL j IN l_Trxn_Tab.first..l_Trxn_Tab.last
4422: INSERT INTO IBY_TRXN_SUMMARIES_ALL VALUES l_Trxn_Tab(j);
4423: END IF;
4424:
4425: print_debuginfo(l_module_name, 'Inserted ' || SQL%ROWCOUNT
4426: || ' transactions');

Line 4707: -- on the corresponding record in iby_trxn_summaries_all

4703: SET payment_system_order_number = l_tangible.Tangible_Id
4704: WHERE trxn_extension_id = p_trxn_entity_id;
4705:
4706: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4707: -- on the corresponding record in iby_trxn_summaries_all
4708: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4709: ||'on the credit record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4710:
4711: UPDATE iby_trxn_summaries_all

Line 4711: UPDATE iby_trxn_summaries_all

4707: -- on the corresponding record in iby_trxn_summaries_all
4708: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4709: ||'on the credit record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4710:
4711: UPDATE iby_trxn_summaries_all
4712: SET initiator_extension_id = p_trxn_entity_id
4713: WHERE transactionid = lx_creditresp.Trxn_Id
4714: AND reqtype = 'ORAPMTCREDIT';
4715:

Line 4755: -- on the corresponding record in iby_trxn_summaries_all

4751: SET payment_system_order_number = l_return_pson
4752: WHERE trxn_extension_id = p_trxn_entity_id;
4753:
4754: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4755: -- on the corresponding record in iby_trxn_summaries_all
4756: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4757: ||'on the return record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4758:
4759: UPDATE iby_trxn_summaries_all

Line 4759: UPDATE iby_trxn_summaries_all

4755: -- on the corresponding record in iby_trxn_summaries_all
4756: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4757: ||'on the return record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4758:
4759: UPDATE iby_trxn_summaries_all
4760: SET initiator_extension_id = p_trxn_entity_id
4761: WHERE transactionid = lx_returnresp.Trxn_Id
4762: AND reqtype = 'ORAPMTRETURN';
4763:

Line 5153: l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)

5149: | NOTES:
5150: |
5151: *---------------------------------------------------------------------*/
5152: FUNCTION get_le_from_bankacct_id(
5153: l_intbankacct_id IN IBY_TRXN_SUMMARIES_ALL.payeeinstrid%TYPE)
5154: RETURN NUMBER
5155: IS
5156:
5157: l_le_id NUMBER;