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.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_EMD_TRANSACTIONS

Line 39: deposit_currency pon_emd_transactions.transaction_currency_code%type,

35: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
36: customer_id ra_customer_trx.bill_to_customer_id%TYPE,
37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
38: deposit_amount NUMBER,
39: deposit_currency pon_emd_transactions.transaction_currency_code%type,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%type,
42: exchange_rate pon_emd_transactions.exchange_rate%type,
43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,

Line 40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,

36: customer_id ra_customer_trx.bill_to_customer_id%TYPE,
37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
38: deposit_amount NUMBER,
39: deposit_currency pon_emd_transactions.transaction_currency_code%type,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%type,
42: exchange_rate pon_emd_transactions.exchange_rate%type,
43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,

Line 41: exchange_date pon_emd_transactions.exchange_date%type,

37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
38: deposit_amount NUMBER,
39: deposit_currency pon_emd_transactions.transaction_currency_code%type,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%type,
42: exchange_rate pon_emd_transactions.exchange_rate%type,
43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,
45: org_id NUMBER,

Line 42: exchange_rate pon_emd_transactions.exchange_rate%type,

38: deposit_amount NUMBER,
39: deposit_currency pon_emd_transactions.transaction_currency_code%type,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%type,
42: exchange_rate pon_emd_transactions.exchange_rate%type,
43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,
45: org_id NUMBER,
46: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,

Line 52: in_favor_of pon_emd_transactions.in_favor_of%type,

48: batch_source_id ra_batch_sources.batch_source_id%TYPE,
49: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
50: memo_line_id NUMBER,
51: paying_location hz_locations.city%TYPE,
52: in_favor_of pon_emd_transactions.in_favor_of%type,
53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,

Line 53: cheque_number pon_emd_transactions.cheque_number%type,

49: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
50: memo_line_id NUMBER,
51: paying_location hz_locations.city%TYPE,
52: in_favor_of pon_emd_transactions.in_favor_of%type,
53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,

Line 54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,

50: memo_line_id NUMBER,
51: paying_location hz_locations.city%TYPE,
52: in_favor_of pon_emd_transactions.in_favor_of%type,
53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,

Line 55: payable_at pon_emd_transactions.payable_at%type,

51: paying_location hz_locations.city%TYPE,
52: in_favor_of pon_emd_transactions.in_favor_of%type,
53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,

Line 56: demand_draft_num pon_emd_transactions.demand_draft_num%type,

52: in_favor_of pon_emd_transactions.in_favor_of%type,
53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,

Line 57: bank_name pon_emd_transactions.bank_name%TYPE,

53: cheque_number pon_emd_transactions.cheque_number%type,
54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,

Line 58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,

54: cash_bearer_name pon_emd_transactions.cash_bearer_name%type,
55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,

Line 59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,

55: payable_at pon_emd_transactions.payable_at%type,
56: demand_draft_num pon_emd_transactions.demand_draft_num%type,
57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE

Line 61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,

57: bank_name pon_emd_transactions.bank_name%TYPE,
58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE
64: );
65:

Line 62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,

58: bank_branch_name pon_emd_transactions.bank_branch_name%TYPE,
59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE
64: );
65:
66: TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD

Line 63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE

59: bank_account_num pon_emd_transactions.bank_account_num%TYPE,
60: payment_trxn_extension_id NUMBER,
61: payment_type_code pon_emd_transactions.payment_type_code%TYPE,
62: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE
64: );
65:
66: TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD
67: ( deposit_trx_number ra_customer_trx.trx_number%TYPE,

Line 155: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE,

151: amount NUMBER,
152: memo_line_id NUMBER,
153: batch_source_id ra_batch_sources.batch_source_id%TYPE,
154: payment_term_id NUMBER,
155: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE,
156: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
157: trx_count_in_group NUMBER,
158: current_trx_number NUMBER
159: );

Line 156: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,

152: memo_line_id NUMBER,
153: batch_source_id ra_batch_sources.batch_source_id%TYPE,
154: payment_term_id NUMBER,
155: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE,
156: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
157: trx_count_in_group NUMBER,
158: current_trx_number NUMBER
159: );
160:

Line 180: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,

176: document_number pon_auction_headers_all.document_number%TYPE,
177: party_id hz_parties.party_id%type,
178: party_site_id hz_party_sites.party_site_id%type,
179: party_contact_id hz_parties.party_id%TYPE,
180: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
181: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE
182: );
183:
184: TYPE CM_INFO_OUT_RECTYPE IS RECORD

Line 181: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE

177: party_id hz_parties.party_id%type,
178: party_site_id hz_party_sites.party_site_id%type,
179: party_contact_id hz_parties.party_id%TYPE,
180: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,
181: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE
182: );
183:
184: TYPE CM_INFO_OUT_RECTYPE IS RECORD
185: (

Line 233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,

229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,

Line 234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,

230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,

Line 235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,

231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,

Line 236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,

232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,

Line 237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,

233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,

Line 238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,

234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,

Line 239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,

235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,

Line 240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,

236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,
237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,

Line 241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,

237: COUNTRY_CODE PON_EMD_TRANSACTIONS.COUNTRY_CODE%TYPE,
238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,

Line 242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,

238: BANK_NAME PON_EMD_TRANSACTIONS.BANK_NAME%TYPE,
239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,

Line 243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,

239: BANK_BRANCH_NAME PON_EMD_TRANSACTIONS.BANK_BRANCH_NAME%TYPE,
240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,

Line 244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,

240: BANK_ACCOUNT_NUM PON_EMD_TRANSACTIONS.BANK_ACCOUNT_NUM%TYPE,
241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,

Line 245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,

241: BANK_ACCOUNT_CURRENCY PON_EMD_TRANSACTIONS.BANK_ACCOUNT_CURRENCY%TYPE,
242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,

Line 246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,

242: BANK_GURANTEE_NUMBER PON_EMD_TRANSACTIONS.BANK_GURANTEE_NUMBER%TYPE,
243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,

Line 247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,

243: IN_FAVOR_OF PON_EMD_TRANSACTIONS.IN_FAVOR_OF%TYPE,
244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,

Line 248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,

244: CHEQUE_NUMBER PON_EMD_TRANSACTIONS.CHEQUE_NUMBER%TYPE,
245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,

Line 249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,

245: CASH_BEARER_NAME PON_EMD_TRANSACTIONS.CASH_BEARER_NAME%TYPE,
246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,

Line 250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,

246: PAYABLE_AT PON_EMD_TRANSACTIONS.PAYABLE_AT%TYPE,
247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,

Line 251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,

247: DEMAND_DRAFT_NUM PON_EMD_TRANSACTIONS.DEMAND_DRAFT_NUM%TYPE,
248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,

Line 252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,

248: CREDIT_CARD_NUM PON_EMD_TRANSACTIONS.CREDIT_CARD_NUM%TYPE,
249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,

Line 253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,

249: NAME_ON_CARD PON_EMD_TRANSACTIONS.NAME_ON_CARD%TYPE,
250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,

Line 254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,

250: CARD_ISSUER_CODE PON_EMD_TRANSACTIONS.CARD_ISSUER_CODE%TYPE,
251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,

Line 255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,

251: PURCHASE_CARD_FLAG PON_EMD_TRANSACTIONS.PURCHASE_CARD_FLAG%TYPE,
252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,

Line 256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,

252: SINGLE_USE_FLAG PON_EMD_TRANSACTIONS.SINGLE_USE_FLAG%TYPE,
253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,

Line 257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,

253: EXPIRY_DATE PON_EMD_TRANSACTIONS.EXPIRY_DATE%TYPE,
254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,

Line 258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,

254: TRANSACTION_CURRENCY_CODE PON_EMD_TRANSACTIONS.TRANSACTION_CURRENCY_CODE%TYPE,
255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,

Line 259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,

255: EXCHANGE_RATE_TYPE PON_EMD_TRANSACTIONS.EXCHANGE_RATE_TYPE%TYPE,
256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,

Line 260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,

256: EXCHANGE_DATE PON_EMD_TRANSACTIONS.EXCHANGE_DATE%TYPE,
257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,

Line 261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,

257: EXCHANGE_RATE PON_EMD_TRANSACTIONS.EXCHANGE_RATE%TYPE,
258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,

Line 262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,

258: AMOUNT PON_EMD_TRANSACTIONS.AMOUNT%TYPE,
259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,

Line 263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,

259: POSTED_TO_FINANCE PON_EMD_TRANSACTIONS.POSTED_TO_FINANCE%TYPE,
260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,

Line 274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,

270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,
275: EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE
276:
277: );
278:

Line 275: EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE

271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,
275: EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE
276:
277: );
278:
279: TYPE pon_emd_trx_info_Tbl_Type IS TABLE OF pon_emd_trx_rec

Line 336: FROM PON_EMD_TRANSACTIONS ET,

332: SUP.VENDOR_ID,
333: PUH.CURRENCY_CODE,
334: ET.ERROR_MESSAGE,
335: ET.EMD_TRANSACTION_GROUP_ID
336: FROM PON_EMD_TRANSACTIONS ET,
337: PON_BIDDING_PARTIES BP,
338: PON_AUCTION_HEADERS_ALL PUH,
339: AP_SUPPLIERS sup
340: WHERE ET.AUCTION_HEADER_ID = BP.AUCTION_HEADER_ID

Line 492: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,

488: x_card_assignment_id OUT NOCOPY NUMBER,
489: x_return_status OUT NOCOPY VARCHAR2);
490: */
491: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
492: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
493: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
494: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
495: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
496: x_org_id OUT NOCOPY NUMBER,

Line 493: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,

489: x_return_status OUT NOCOPY VARCHAR2);
490: */
491: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
492: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
493: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
494: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
495: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
496: x_org_id OUT NOCOPY NUMBER,
497: x_return_status OUT NOCOPY VARCHAR2);

Line 494: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,

490: */
491: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
492: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
493: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
494: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
495: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
496: x_org_id OUT NOCOPY NUMBER,
497: x_return_status OUT NOCOPY VARCHAR2);
498: