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.IGS_FI_CREDITS_API_PUB dependencies on IGS_FI_CREDITS_ALL

Line 36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,

32:
33: PROCEDURE create_credit(p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2,
35: p_commit IN VARCHAR2,
36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,
37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,

Line 37: p_credit_status IN igs_fi_credits_all.status%TYPE ,

33: PROCEDURE create_credit(p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2,
35: p_commit IN VARCHAR2,
36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,
37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,

Line 38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,

34: p_init_msg_list IN VARCHAR2,
35: p_commit IN VARCHAR2,
36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,
37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,

Line 39: p_party_id IN igs_fi_credits_all.party_id%TYPE,

35: p_commit IN VARCHAR2,
36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,
37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,

Line 40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,

36: p_credit_number IN igs_fi_credits_all.credit_number%TYPE,
37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,

Line 41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,

37: p_credit_status IN igs_fi_credits_all.status%TYPE ,
38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,

Line 42: p_description IN igs_fi_credits_all.description%TYPE,

38: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,

Line 43: p_amount IN igs_fi_credits_all.amount%TYPE,

39: p_party_id IN igs_fi_credits_all.party_id%TYPE,
40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,

Line 44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,

40: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,

Line 45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,

41: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */

Line 46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,

42: p_description IN igs_fi_credits_all.description%TYPE,
43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,

Line 47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,

43: p_amount IN igs_fi_credits_all.amount%TYPE,
44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,

Line 48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,

44: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
45: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,

Line 50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,

46: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,

Line 51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,

47: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,

Line 52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,

48: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
56: p_attribute_record IN attribute_rec_type,

Line 53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,

49: /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
56: p_attribute_record IN attribute_rec_type,
57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715

Line 54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,

50: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
56: p_attribute_record IN attribute_rec_type,
57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715
58: /* Parameters added as part of bug:2191470 - sfcr020 */

Line 55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,

51: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
52: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
53: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
54: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
56: p_attribute_record IN attribute_rec_type,
57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715
58: /* Parameters added as part of bug:2191470 - sfcr020 */
59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,

Line 59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,

55: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
56: p_attribute_record IN attribute_rec_type,
57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715
58: /* Parameters added as part of bug:2191470 - sfcr020 */
59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

Line 60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,

56: p_attribute_record IN attribute_rec_type,
57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715
58: /* Parameters added as part of bug:2191470 - sfcr020 */
59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
64: /* Parameters added as part of bug:2191470 - sfcr020 */

Line 61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,

57: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,--bug:2195715
58: /* Parameters added as part of bug:2191470 - sfcr020 */
59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
64: /* Parameters added as part of bug:2191470 - sfcr020 */
65: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,

Line 62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,

58: /* Parameters added as part of bug:2191470 - sfcr020 */
59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
64: /* Parameters added as part of bug:2191470 - sfcr020 */
65: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
66: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,

Line 63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

59: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
60: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
64: /* Parameters added as part of bug:2191470 - sfcr020 */
65: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
66: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2,

Line 65: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,

61: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
62: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
63: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
64: /* Parameters added as part of bug:2191470 - sfcr020 */
65: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
66: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,

Line 76: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,

72: p_v_source_tran_ref_number IN VARCHAR2,
73: p_v_credit_card_payee_cd IN VARCHAR2,
74: p_v_credit_card_status_code IN VARCHAR2,
75: p_v_credit_card_tangible_cd IN VARCHAR2,
76: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
77: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
78: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE
79: )AS
80: /***********************************************************************************************

Line 77: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,

73: p_v_credit_card_payee_cd IN VARCHAR2,
74: p_v_credit_card_status_code IN VARCHAR2,
75: p_v_credit_card_tangible_cd IN VARCHAR2,
76: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
77: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
78: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE
79: )AS
80: /***********************************************************************************************
81:

Line 78: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE

74: p_v_credit_card_status_code IN VARCHAR2,
75: p_v_credit_card_tangible_cd IN VARCHAR2,
76: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
77: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
78: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE
79: )AS
80: /***********************************************************************************************
81:
82: Created By: Amit Gairola

Line 142: l_credit_number igs_fi_credits_all.credit_number%TYPE;

138: msrinivi 13 Aug,2001 Call to build process to populate rev/rec ccid/code before
139: inserting intoigs_fi_activities table
140: ********************************************************************************************** */
141:
142: l_credit_number igs_fi_credits_all.credit_number%TYPE;
143:
144: BEGIN
145:
146: create_credit( p_api_version => p_api_version,

Line 197: p_credit_status IN igs_fi_credits_all.status%TYPE ,

193:
194: PROCEDURE create_credit(p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2,
196: p_commit IN VARCHAR2,
197: p_credit_status IN igs_fi_credits_all.status%TYPE ,
198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,

Line 198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,

194: PROCEDURE create_credit(p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2,
196: p_commit IN VARCHAR2,
197: p_credit_status IN igs_fi_credits_all.status%TYPE ,
198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,

Line 199: p_party_id IN igs_fi_credits_all.party_id%TYPE,

195: p_init_msg_list IN VARCHAR2,
196: p_commit IN VARCHAR2,
197: p_credit_status IN igs_fi_credits_all.status%TYPE ,
198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,

Line 200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,

196: p_commit IN VARCHAR2,
197: p_credit_status IN igs_fi_credits_all.status%TYPE ,
198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,

Line 201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,

197: p_credit_status IN igs_fi_credits_all.status%TYPE ,
198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,

Line 202: p_description IN igs_fi_credits_all.description%TYPE,

198: p_credit_source IN igs_fi_credits_all.credit_source%TYPE,
199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,

Line 203: p_amount IN igs_fi_credits_all.amount%TYPE,

199: p_party_id IN igs_fi_credits_all.party_id%TYPE,
200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,

Line 204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,

200: p_credit_type_id IN igs_fi_credits_all.credit_type_id%TYPE,
201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,

Line 205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,

201: p_credit_instrument IN igs_fi_credits_all.credit_instrument%TYPE,
202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,

Line 206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,

202: p_description IN igs_fi_credits_all.description%TYPE,
203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,

Line 207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,

203: p_amount IN igs_fi_credits_all.amount%TYPE,
204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,

Line 208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,

204: p_currency_cd IN igs_fi_credits_all.currency_cd%TYPE,
205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,

Line 209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,

205: p_exchange_rate IN igs_fi_credits_all.exchange_rate%TYPE,
206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,

Line 210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,

206: p_transaction_date IN igs_fi_credits_all.transaction_date%TYPE,
207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,

Line 211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,

207: p_effective_date IN igs_fi_credits_all.effective_date%TYPE,
208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,

Line 212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,

208: p_source_transaction_id IN igs_fi_credits_all.source_transaction_id%TYPE,
209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,

209: p_receipt_lockbox_number IN igs_fi_credits_all.receipt_lockbox_number%TYPE,
210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,

Line 214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,

210: p_credit_card_code IN igs_fi_credits_all.credit_card_code%TYPE,
211: p_credit_card_holder_name IN igs_fi_credits_all.credit_card_holder_name%TYPE,
212: p_credit_card_number IN igs_fi_credits_all.credit_card_number%TYPE,
213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,

Line 217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,

213: p_credit_card_expiration_date IN igs_fi_credits_all.credit_card_expiration_date%TYPE,
214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

Line 218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,

214: p_credit_card_approval_code IN igs_fi_credits_all.credit_card_approval_code%TYPE,
215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,

Line 219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,

215: p_attribute_record IN attribute_rec_type,
216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
223: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,

Line 220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,

216: p_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
223: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2,

Line 221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,

217: p_awd_yr_cal_type IN igs_fi_credits_all.awd_yr_cal_type%TYPE,
218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
223: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,

Line 222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,

218: p_awd_yr_ci_sequence_number IN igs_fi_credits_all.awd_yr_ci_sequence_number%TYPE,
219: p_fee_cal_type IN igs_fi_credits_all.fee_cal_type%TYPE,
220: p_fee_ci_sequence_number IN igs_fi_credits_all.fee_ci_sequence_number%TYPE,
221: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
222: x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
223: x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,

Line 233: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,

229: p_v_source_tran_ref_number IN VARCHAR2,
230: p_v_credit_card_payee_cd IN VARCHAR2,
231: p_v_credit_card_status_code IN VARCHAR2,
232: p_v_credit_card_tangible_cd IN VARCHAR2,
233: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
234: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
235: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE,
236: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
237: )AS

Line 234: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,

230: p_v_credit_card_payee_cd IN VARCHAR2,
231: p_v_credit_card_status_code IN VARCHAR2,
232: p_v_credit_card_tangible_cd IN VARCHAR2,
233: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
234: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
235: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE,
236: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
237: )AS
238:

Line 235: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE,

231: p_v_credit_card_status_code IN VARCHAR2,
232: p_v_credit_card_tangible_cd IN VARCHAR2,
233: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
234: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
235: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE,
236: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
237: )AS
238:
239: /***********************************************************************************************

Line 236: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE

232: p_v_credit_card_tangible_cd IN VARCHAR2,
233: p_lockbox_interface_id IN igs_fi_credits_all.lockbox_interface_id%TYPE,
234: p_batch_name IN igs_fi_credits_all.batch_name%TYPE,
235: p_deposit_date IN igs_fi_credits_all.deposit_date%TYPE,
236: x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
237: )AS
238:
239: /***********************************************************************************************
240: