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.ARP_PROCESS_BR_REMIT dependencies on AR_BATCHES

Line 47: p_batch_date IN AR_BATCHES.batch_date%TYPE,

43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: x_msg_count OUT NOCOPY NUMBER ,
46: x_msg_data OUT NOCOPY VARCHAR2 ,
47: p_batch_date IN AR_BATCHES.batch_date%TYPE,
48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

Line 48: p_gl_date IN AR_BATCHES.gl_date%TYPE,

44: x_return_status OUT NOCOPY VARCHAR2 ,
45: x_msg_count OUT NOCOPY NUMBER ,
46: x_msg_data OUT NOCOPY VARCHAR2 ,
47: p_batch_date IN AR_BATCHES.batch_date%TYPE,
48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

Line 49: p_currency_code IN AR_BATCHES.currency_code%TYPE,

45: x_msg_count OUT NOCOPY NUMBER ,
46: x_msg_data OUT NOCOPY VARCHAR2 ,
47: p_batch_date IN AR_BATCHES.batch_date%TYPE,
48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

Line 50: p_comments IN AR_BATCHES.comments%TYPE,

46: x_msg_data OUT NOCOPY VARCHAR2 ,
47: p_batch_date IN AR_BATCHES.batch_date%TYPE,
48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

Line 51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,

47: p_batch_date IN AR_BATCHES.batch_date%TYPE,
48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

Line 52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,

48: p_gl_date IN AR_BATCHES.gl_date%TYPE,
49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

Line 53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,

49: p_currency_code IN AR_BATCHES.currency_code%TYPE,
50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

Line 54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,

50: p_comments IN AR_BATCHES.comments%TYPE,
51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

Line 55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,

51: p_attribute_category IN AR_BATCHES.attribute_category%TYPE,
52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

Line 56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,

52: p_attribute1 IN AR_BATCHES.attribute1%TYPE,
53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

Line 57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,

53: p_attribute2 IN AR_BATCHES.attribute2%TYPE,
54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

Line 58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,

54: p_attribute3 IN AR_BATCHES.attribute3%TYPE,
55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,

Line 59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,

55: p_attribute4 IN AR_BATCHES.attribute4%TYPE,
56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

Line 60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,

56: p_attribute5 IN AR_BATCHES.attribute5%TYPE,
57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

Line 61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,

57: p_attribute6 IN AR_BATCHES.attribute6%TYPE,
58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

Line 62: p_media_reference IN AR_BATCHES.media_reference%TYPE,

58: p_attribute7 IN AR_BATCHES.attribute7%TYPE,
59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

Line 63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,

59: p_attribute8 IN AR_BATCHES.attribute8%TYPE,
60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

Line 64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

60: p_attribute9 IN AR_BATCHES.attribute9%TYPE,
61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

Line 65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,

61: p_attribute10 IN AR_BATCHES.attribute10%TYPE,
62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

Line 66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,

62: p_media_reference IN AR_BATCHES.media_reference%TYPE,
63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

Line 67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,

63: p_receipt_method_id IN AR_BATCHES.receipt_method_id%TYPE,
64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

Line 68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,

64: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

Line 69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,

65: p_receipt_class_id IN AR_BATCHES.receipt_class_id%TYPE,
66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

Line 70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,

66: p_remittance_bank_branch_id IN AR_BATCHES.remittance_bank_branch_id%TYPE,
67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,

67: p_remit_method_code IN AR_BATCHES.remit_method_code%TYPE,
68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

68: p_with_recourse_flag IN AR_BATCHES.with_recourse_flag%TYPE,
69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

69: p_bank_deposit_number IN AR_BATCHES.bank_deposit_number%TYPE,
70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,

95: p_br_sort_criteria IN varchar2,
96: p_br_order IN varchar2,
97: p_drawee_sort_criteria IN varchar2,
98: p_drawee_order IN varchar2,
99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

Line 100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,

96: p_br_order IN varchar2,
97: p_drawee_sort_criteria IN varchar2,
98: p_drawee_order IN varchar2,
99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
104:

Line 101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

97: p_drawee_sort_criteria IN varchar2,
98: p_drawee_order IN varchar2,
99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
104:
105:

Line 102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,

98: p_drawee_order IN varchar2,
99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
104:
105:
106: l_api_name CONSTANT varchar2(30) := 'create_remit_batch';

Line 103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

99: p_batch_id OUT NOCOPY AR_BATCHES.batch_id%TYPE,
100: p_batch_name OUT NOCOPY AR_BATCHES.name%TYPE,
101: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
102: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
103: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
104:
105:
106: l_api_name CONSTANT varchar2(30) := 'create_remit_batch';
107: l_api_version CONSTANT number := 1.0;

Line 112: l_batch_rec AR_BATCHES%ROWTYPE;

108:
109: CUR_BR CUR_TYP;
110: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
111:
112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;

Line 113: l_batch_id AR_BATCHES.batch_id%TYPE;

109: CUR_BR CUR_TYP;
110: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
111:
112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;
117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

Line 114: l_batch_name AR_BATCHES.name%TYPE;

110: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
111:
112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;
117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
118:

Line 115: l_control_count AR_BATCHES.control_count%TYPE;

111:
112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;
117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
118:
119: l_select_detail varchar2(25000) := NULL;

Line 116: l_control_amount AR_BATCHES.control_amount%TYPE;

112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;
117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
118:
119: l_select_detail varchar2(25000) := NULL;
120: l_field varchar2(30) := NULL;

Line 117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;
115: l_control_count AR_BATCHES.control_count%TYPE;
116: l_control_amount AR_BATCHES.control_amount%TYPE;
117: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
118:
119: l_select_detail varchar2(25000) := NULL;
120: l_field varchar2(30) := NULL;
121:

Line 190: -- the remittance is inserted in AR_BATCHES and the insert is committed

186: p_drawee_order,
187: l_select_detail);
188:
189: -- IF some BR are selected with the user parameters,
190: -- the remittance is inserted in AR_BATCHES and the insert is committed
191: OPEN CUR_BR FOR l_select_detail
192: USING p_include_unpaid_flag,
193: p_batch_date,
194: p_gl_date,

Line 232: -- Some BR have been selected -> Insert of the remittance batch row in the table AR_BATCHES

228: CLOSE CUR_BR;
229:
230: IF ((p_remit_total_low IS NULL) AND (TOTAL_COUNT > 0)) OR
231: ((p_remit_total_low IS NOT NULL) AND (TOTAL_AMOUNT BETWEEN p_remit_total_low AND p_remit_total_high) AND (TOTAL_COUNT > 0)) THEN
232: -- Some BR have been selected -> Insert of the remittance batch row in the table AR_BATCHES
233: ARP_BR_REMIT_BATCHES.insert_remit(
234: p_batch_date,
235: p_gl_date,
236: p_currency_code,

Line 268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES

264: arp_util.debug('create_remit_batch: ' || 'NB selected BR :'|| TOTAL_COUNT);
265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
266: END IF;
267: ELSE
268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES
269: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_REMIT');
270: APP_EXCEPTION.raise_exception;
271: END IF;
272:

Line 369: p_batch_id IN AR_BATCHES.batch_id%TYPE,

365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT NOCOPY VARCHAR2 ,
367: x_msg_count OUT NOCOPY NUMBER ,
368: x_msg_data OUT NOCOPY VARCHAR2 ,
369: p_batch_id IN AR_BATCHES.batch_id%TYPE,
370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

366: x_return_status OUT NOCOPY VARCHAR2 ,
367: x_msg_count OUT NOCOPY NUMBER ,
368: x_msg_data OUT NOCOPY VARCHAR2 ,
369: p_batch_id IN AR_BATCHES.batch_id%TYPE,
370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

367: x_msg_count OUT NOCOPY NUMBER ,
368: x_msg_data OUT NOCOPY VARCHAR2 ,
369: p_batch_id IN AR_BATCHES.batch_id%TYPE,
370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 397: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

393: p_br_sort_criteria IN varchar2,
394: p_br_order IN varchar2,
395: p_drawee_sort_criteria IN varchar2,
396: p_drawee_order IN varchar2,
397: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
398: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
399: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
400:
401: l_api_name CONSTANT varchar2(30) := 'select_and_assign_br_to_remit';

Line 398: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,

394: p_br_order IN varchar2,
395: p_drawee_sort_criteria IN varchar2,
396: p_drawee_order IN varchar2,
397: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
398: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
399: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
400:
401: l_api_name CONSTANT varchar2(30) := 'select_and_assign_br_to_remit';
402: l_api_version CONSTANT number := 1.0;

Line 399: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

395: p_drawee_sort_criteria IN varchar2,
396: p_drawee_order IN varchar2,
397: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
398: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
399: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
400:
401: l_api_name CONSTANT varchar2(30) := 'select_and_assign_br_to_remit';
402: l_api_version CONSTANT number := 1.0;
403:

Line 404: l_batch_rec AR_BATCHES%ROWTYPE;

400:
401: l_api_name CONSTANT varchar2(30) := 'select_and_assign_br_to_remit';
402: l_api_version CONSTANT number := 1.0;
403:
404: l_batch_rec AR_BATCHES%ROWTYPE;
405:
406: l_select_detail varchar2(25000);
407:
408: l_control_count AR_BATCHES.control_count%TYPE;

Line 408: l_control_count AR_BATCHES.control_count%TYPE;

404: l_batch_rec AR_BATCHES%ROWTYPE;
405:
406: l_select_detail varchar2(25000);
407:
408: l_control_count AR_BATCHES.control_count%TYPE;
409: l_control_amount AR_BATCHES.control_amount%TYPE;
410:
411: BEGIN
412:

Line 409: l_control_amount AR_BATCHES.control_amount%TYPE;

405:
406: l_select_detail varchar2(25000);
407:
408: l_control_count AR_BATCHES.control_count%TYPE;
409: l_control_amount AR_BATCHES.control_amount%TYPE;
410:
411: BEGIN
412:
413: IF PG_DEBUG in ('Y', 'C') THEN

Line 589: l_ps_status_opened AR_BATCHES.status%TYPE := 'OP';

585:
586: l_flag_yes varchar2(1) := 'Y';
587: l_flag_no varchar2(1) := 'N';
588:
589: l_ps_status_opened AR_BATCHES.status%TYPE := 'OP';
590: l_ps_class AR_PAYMENT_SCHEDULES.CLASS%TYPE := 'BR';
591:
592: l_pending_remittance AR_TRANSACTION_HISTORY.status%TYPE := 'PENDING_REMITTANCE';
593: l_unpaid AR_TRANSACTION_HISTORY.status%TYPE := 'UNPAID';

Line 800: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

796: | instead of customer name and |
797: | customer number |
798: +===========================================================================*/
799: PROCEDURE validate_br_search_criteria(
800: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
801: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
802: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
803: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
804: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 801: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

797: | customer number |
798: +===========================================================================*/
799: PROCEDURE validate_br_search_criteria(
800: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
801: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
802: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
803: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
804: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
805: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 1023: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1019: | |
1020: +===========================================================================*/
1021: PROCEDURE assign_br_to_remit(
1022: p_select_detail IN varchar2,
1023: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,

Line 1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

1020: +===========================================================================*/
1021: PROCEDURE assign_br_to_remit(
1022: p_select_detail IN varchar2,
1023: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,

Line 1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,

1022: p_select_detail IN varchar2,
1023: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1029: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1030: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,

1023: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1029: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1030: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1031: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,

1024: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1029: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1030: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1031: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1032: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 1029: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,

1025: p_include_unpaid_flag IN varchar2,
1026: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1027: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1028: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1029: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1030: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1031: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1032: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1033: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

1038: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1043: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1044:
1045: CUR_BR CUR_TYP;
1046: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

Line 1043: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS

1039: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1040: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1041: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1042: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1043: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1044:
1045: CUR_BR CUR_TYP;
1046: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1047:

Line 1048: TOTAL_COUNT AR_BATCHES.control_count%TYPE;

1044:
1045: CUR_BR CUR_TYP;
1046: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1047:
1048: TOTAL_COUNT AR_BATCHES.control_count%TYPE;
1049: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;
1050:
1051: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1052:

Line 1049: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;

1045: CUR_BR CUR_TYP;
1046: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1047:
1048: TOTAL_COUNT AR_BATCHES.control_count%TYPE;
1049: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;
1050:
1051: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1052:
1053: BEGIN

Line 1171: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1168: x_return_status OUT NOCOPY VARCHAR2 ,
1169: x_msg_count OUT NOCOPY NUMBER ,
1170: x_msg_data OUT NOCOPY VARCHAR2 ,
1171: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1172: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
1173: p_action_flag IN varchar2,
1174: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1175: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS

Line 1174: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

1170: x_msg_data OUT NOCOPY VARCHAR2 ,
1171: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1172: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
1173: p_action_flag IN varchar2,
1174: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1175: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1176:
1177: l_api_name CONSTANT varchar2(30) := 'add_or_rm_br_to_remit';
1178: l_api_version CONSTANT number := 1.0;

Line 1175: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS

1171: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1172: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
1173: p_action_flag IN varchar2,
1174: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1175: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1176:
1177: l_api_name CONSTANT varchar2(30) := 'add_or_rm_br_to_remit';
1178: l_api_version CONSTANT number := 1.0;
1179:

Line 1184: l_batch_rec AR_BATCHES%ROWTYPE;

1180: l_field varchar2(30) := NULL;
1181:
1182: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1183:
1184: l_batch_rec AR_BATCHES%ROWTYPE;
1185: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1186:
1187: l_control_count AR_BATCHES.control_count%TYPE;
1188: l_control_amount AR_BATCHES.control_amount%TYPE;

Line 1187: l_control_count AR_BATCHES.control_count%TYPE;

1183:
1184: l_batch_rec AR_BATCHES%ROWTYPE;
1185: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1186:
1187: l_control_count AR_BATCHES.control_count%TYPE;
1188: l_control_amount AR_BATCHES.control_amount%TYPE;
1189: l_br_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
1190:
1191: BEGIN

Line 1188: l_control_amount AR_BATCHES.control_amount%TYPE;

1184: l_batch_rec AR_BATCHES%ROWTYPE;
1185: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1186:
1187: l_control_count AR_BATCHES.control_count%TYPE;
1188: l_control_amount AR_BATCHES.control_amount%TYPE;
1189: l_br_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
1190:
1191: BEGIN
1192:

Line 1357: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1353: p_format_flag IN varchar2,
1354: p_print_flag IN varchar2,
1355: p_cancel_flag IN varchar2,
1356: p_print_bills_flag IN varchar2,
1357: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1358: p_physical_bill IN varchar2,
1359: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1360: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1361: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

Line 1359: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,

1355: p_cancel_flag IN varchar2,
1356: p_print_bills_flag IN varchar2,
1357: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1358: p_physical_bill IN varchar2,
1359: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1360: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1361: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1362: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1363: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 1360: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,

1356: p_print_bills_flag IN varchar2,
1357: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1358: p_physical_bill IN varchar2,
1359: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1360: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1361: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1362: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1363: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1364: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

Line 1386: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

1382: p_br_sort_criteria IN varchar2,
1383: p_br_order IN varchar2,
1384: p_drawee_sort_criteria IN varchar2,
1385: p_drawee_order IN varchar2,
1386: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1387: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1388: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1389: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1390:

Line 1387: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,

1383: p_br_order IN varchar2,
1384: p_drawee_sort_criteria IN varchar2,
1385: p_drawee_order IN varchar2,
1386: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1387: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1388: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1389: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1390:
1391: l_api_name CONSTANT varchar2(30) := 'create_remit_batch_conc_req';

Line 1388: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,

1384: p_drawee_sort_criteria IN varchar2,
1385: p_drawee_order IN varchar2,
1386: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1387: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1388: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1389: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1390:
1391: l_api_name CONSTANT varchar2(30) := 'create_remit_batch_conc_req';
1392: l_api_version CONSTANT number := 1.0;

Line 1389: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

1385: p_drawee_order IN varchar2,
1386: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1387: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1388: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1389: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1390:
1391: l_api_name CONSTANT varchar2(30) := 'create_remit_batch_conc_req';
1392: l_api_version CONSTANT number := 1.0;
1393:

Line 1398: l_batch_rec AR_BATCHES%ROWTYPE;

1394: l_program varchar2(30) := 'ARBRRMCP';
1395:
1396: l_field varchar2(30) := NULL;
1397:
1398: l_batch_rec AR_BATCHES%ROWTYPE;
1399: l_control_count AR_BATCHES.control_count%TYPE;
1400: l_control_amount AR_BATCHES.control_amount%TYPE;
1401: l_request_id AR_BATCHES.operation_request_id%TYPE;
1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

Line 1399: l_control_count AR_BATCHES.control_count%TYPE;

1395:
1396: l_field varchar2(30) := NULL;
1397:
1398: l_batch_rec AR_BATCHES%ROWTYPE;
1399: l_control_count AR_BATCHES.control_count%TYPE;
1400: l_control_amount AR_BATCHES.control_amount%TYPE;
1401: l_request_id AR_BATCHES.operation_request_id%TYPE;
1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1403: l_org_id number;

Line 1400: l_control_amount AR_BATCHES.control_amount%TYPE;

1396: l_field varchar2(30) := NULL;
1397:
1398: l_batch_rec AR_BATCHES%ROWTYPE;
1399: l_control_count AR_BATCHES.control_count%TYPE;
1400: l_control_amount AR_BATCHES.control_amount%TYPE;
1401: l_request_id AR_BATCHES.operation_request_id%TYPE;
1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1403: l_org_id number;
1404: BEGIN

Line 1401: l_request_id AR_BATCHES.operation_request_id%TYPE;

1397:
1398: l_batch_rec AR_BATCHES%ROWTYPE;
1399: l_control_count AR_BATCHES.control_count%TYPE;
1400: l_control_amount AR_BATCHES.control_amount%TYPE;
1401: l_request_id AR_BATCHES.operation_request_id%TYPE;
1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1403: l_org_id number;
1404: BEGIN
1405:

Line 1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

1398: l_batch_rec AR_BATCHES%ROWTYPE;
1399: l_control_count AR_BATCHES.control_count%TYPE;
1400: l_control_amount AR_BATCHES.control_amount%TYPE;
1401: l_request_id AR_BATCHES.operation_request_id%TYPE;
1402: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1403: l_org_id number;
1404: BEGIN
1405:
1406: SAVEPOINT create_conc_req_PVT;

Line 1612: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1608: p_format_flag IN varchar2,
1609: p_print_flag IN varchar2,
1610: p_cancel_flag IN varchar2,
1611: p_print_bills_flag IN varchar2,
1612: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1613: p_physical_bill IN varchar2,
1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,

Line 1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,

1610: p_cancel_flag IN varchar2,
1611: p_print_bills_flag IN varchar2,
1612: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1613: p_physical_bill IN varchar2,
1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1617: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1618:

Line 1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,

1611: p_print_bills_flag IN varchar2,
1612: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1613: p_physical_bill IN varchar2,
1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1617: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1618:
1619: l_api_name CONSTANT varchar2(30) := 'maintain_remit_batch_conc_req';

Line 1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,

1612: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1613: p_physical_bill IN varchar2,
1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1617: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1618:
1619: l_api_name CONSTANT varchar2(30) := 'maintain_remit_batch_conc_req';
1620: l_api_version CONSTANT number := 1.0;

Line 1617: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

1613: p_physical_bill IN varchar2,
1614: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1615: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE,
1616: p_request_id OUT NOCOPY AR_BATCHES.operation_request_id%TYPE,
1617: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1618:
1619: l_api_name CONSTANT varchar2(30) := 'maintain_remit_batch_conc_req';
1620: l_api_version CONSTANT number := 1.0;
1621:

Line 1624: l_batch_rec AR_BATCHES%ROWTYPE;

1620: l_api_version CONSTANT number := 1.0;
1621:
1622: l_program varchar2(30) := 'ARBRRMCP';
1623:
1624: l_batch_rec AR_BATCHES%ROWTYPE;
1625: l_control_count AR_BATCHES.control_count%TYPE;
1626: l_control_amount AR_BATCHES.control_amount%TYPE;
1627: l_request_id AR_BATCHES.operation_request_id%TYPE;
1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

Line 1625: l_control_count AR_BATCHES.control_count%TYPE;

1621:
1622: l_program varchar2(30) := 'ARBRRMCP';
1623:
1624: l_batch_rec AR_BATCHES%ROWTYPE;
1625: l_control_count AR_BATCHES.control_count%TYPE;
1626: l_control_amount AR_BATCHES.control_amount%TYPE;
1627: l_request_id AR_BATCHES.operation_request_id%TYPE;
1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1629:

Line 1626: l_control_amount AR_BATCHES.control_amount%TYPE;

1622: l_program varchar2(30) := 'ARBRRMCP';
1623:
1624: l_batch_rec AR_BATCHES%ROWTYPE;
1625: l_control_count AR_BATCHES.control_count%TYPE;
1626: l_control_amount AR_BATCHES.control_amount%TYPE;
1627: l_request_id AR_BATCHES.operation_request_id%TYPE;
1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1629:
1630: l_field varchar2(30) := NULL;

Line 1627: l_request_id AR_BATCHES.operation_request_id%TYPE;

1623:
1624: l_batch_rec AR_BATCHES%ROWTYPE;
1625: l_control_count AR_BATCHES.control_count%TYPE;
1626: l_control_amount AR_BATCHES.control_amount%TYPE;
1627: l_request_id AR_BATCHES.operation_request_id%TYPE;
1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1629:
1630: l_field varchar2(30) := NULL;
1631:

Line 1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;

1624: l_batch_rec AR_BATCHES%ROWTYPE;
1625: l_control_count AR_BATCHES.control_count%TYPE;
1626: l_control_amount AR_BATCHES.control_amount%TYPE;
1627: l_request_id AR_BATCHES.operation_request_id%TYPE;
1628: l_batch_applied_status AR_BATCHES.batch_applied_status%TYPE;
1629:
1630: l_field varchar2(30) := NULL;
1631:
1632: p_create_flag varchar2(1) := 'N';

Line 1851: p_batch_id IN AR_BATCHES.batch_id%TYPE,

1847: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1848: x_return_status OUT NOCOPY varchar2,
1849: x_msg_count OUT NOCOPY number,
1850: x_msg_data OUT NOCOPY varchar2,
1851: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1852: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1853:
1854: l_api_name CONSTANT varchar2(30) := 'update_batch_status';
1855: l_api_version CONSTANT number := 1.0;

Line 1852: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS

1848: x_return_status OUT NOCOPY varchar2,
1849: x_msg_count OUT NOCOPY number,
1850: x_msg_data OUT NOCOPY varchar2,
1851: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1852: p_batch_applied_status OUT NOCOPY AR_BATCHES.batch_applied_status%TYPE) IS
1853:
1854: l_api_name CONSTANT varchar2(30) := 'update_batch_status';
1855: l_api_version CONSTANT number := 1.0;
1856:

Line 1857: l_batch_rec AR_BATCHES%ROWTYPE;

1853:
1854: l_api_name CONSTANT varchar2(30) := 'update_batch_status';
1855: l_api_version CONSTANT number := 1.0;
1856:
1857: l_batch_rec AR_BATCHES%ROWTYPE;
1858:
1859: BEGIN
1860:
1861: IF PG_DEBUG in ('Y', 'C') THEN