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.CN_PMT_TRANS_PKG dependencies on CN_API

Line 112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),

108: org_id,
109: object_version_number
110: )
111: (SELECT l_payment_transaction_id,
112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),
113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),
114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),

Line 113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),

109: object_version_number
110: )
111: (SELECT l_payment_transaction_id,
112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),
113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),
114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),

Line 114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),

110: )
111: (SELECT l_payment_transaction_id,
112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),
113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),
114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),

Line 115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),

111: (SELECT l_payment_transaction_id,
112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),
113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),
114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),

Line 116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),

112: DECODE (p_tran_rec.posting_batch_id, cn_api.g_miss_id, NULL, p_tran_rec.posting_batch_id),
113: DECODE (p_tran_rec.credited_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.credited_salesrep_id),
114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),
120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),

Line 118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),

114: DECODE (p_tran_rec.payee_salesrep_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_salesrep_id),
115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),
120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),
121: DECODE (p_tran_rec.payment_amount, cn_api.g_miss_num, 0, p_tran_rec.payment_amount),
122: DECODE (p_tran_rec.hold_flag, fnd_api.g_miss_char, 'N', p_tran_rec.hold_flag),

Line 119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),

115: DECODE (p_tran_rec.quota_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_id),
116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),
120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),
121: DECODE (p_tran_rec.payment_amount, cn_api.g_miss_num, 0, p_tran_rec.payment_amount),
122: DECODE (p_tran_rec.hold_flag, fnd_api.g_miss_char, 'N', p_tran_rec.hold_flag),
123: DECODE (p_tran_rec.paid_flag, fnd_api.g_miss_char, 'N', p_tran_rec.paid_flag),

Line 120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),

116: DECODE (p_tran_rec.pay_period_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_period_id),
117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),
120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),
121: DECODE (p_tran_rec.payment_amount, cn_api.g_miss_num, 0, p_tran_rec.payment_amount),
122: DECODE (p_tran_rec.hold_flag, fnd_api.g_miss_char, 'N', p_tran_rec.hold_flag),
123: DECODE (p_tran_rec.paid_flag, fnd_api.g_miss_char, 'N', p_tran_rec.paid_flag),
124: DECODE (p_tran_rec.waive_flag, fnd_api.g_miss_char, 'N', p_tran_rec.waive_flag),

Line 121: DECODE (p_tran_rec.payment_amount, cn_api.g_miss_num, 0, p_tran_rec.payment_amount),

117: DECODE (p_tran_rec.incentive_type_code, fnd_api.g_miss_char, NULL, p_tran_rec.incentive_type_code),
118: DECODE (p_tran_rec.credit_type_id, cn_api.g_miss_id, -1000, p_tran_rec.credit_type_id),
119: DECODE (p_tran_rec.payrun_id, cn_api.g_miss_id, NULL, p_tran_rec.payrun_id),
120: DECODE (p_tran_rec.amount, cn_api.g_miss_num, 0, p_tran_rec.amount),
121: DECODE (p_tran_rec.payment_amount, cn_api.g_miss_num, 0, p_tran_rec.payment_amount),
122: DECODE (p_tran_rec.hold_flag, fnd_api.g_miss_char, 'N', p_tran_rec.hold_flag),
123: DECODE (p_tran_rec.paid_flag, fnd_api.g_miss_char, 'N', p_tran_rec.paid_flag),
124: DECODE (p_tran_rec.waive_flag, fnd_api.g_miss_char, 'N', p_tran_rec.waive_flag),
125: DECODE (p_tran_rec.recoverable_flag, fnd_api.g_miss_char, 'N', p_tran_rec.recoverable_flag),

Line 126: DECODE (p_tran_rec.commission_header_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_header_id),

122: DECODE (p_tran_rec.hold_flag, fnd_api.g_miss_char, 'N', p_tran_rec.hold_flag),
123: DECODE (p_tran_rec.paid_flag, fnd_api.g_miss_char, 'N', p_tran_rec.paid_flag),
124: DECODE (p_tran_rec.waive_flag, fnd_api.g_miss_char, 'N', p_tran_rec.waive_flag),
125: DECODE (p_tran_rec.recoverable_flag, fnd_api.g_miss_char, 'N', p_tran_rec.recoverable_flag),
126: DECODE (p_tran_rec.commission_header_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_header_id),
127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),
128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),

Line 127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),

123: DECODE (p_tran_rec.paid_flag, fnd_api.g_miss_char, 'N', p_tran_rec.paid_flag),
124: DECODE (p_tran_rec.waive_flag, fnd_api.g_miss_char, 'N', p_tran_rec.waive_flag),
125: DECODE (p_tran_rec.recoverable_flag, fnd_api.g_miss_char, 'N', p_tran_rec.recoverable_flag),
126: DECODE (p_tran_rec.commission_header_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_header_id),
127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),
128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),

Line 128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),

124: DECODE (p_tran_rec.waive_flag, fnd_api.g_miss_char, 'N', p_tran_rec.waive_flag),
125: DECODE (p_tran_rec.recoverable_flag, fnd_api.g_miss_char, 'N', p_tran_rec.recoverable_flag),
126: DECODE (p_tran_rec.commission_header_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_header_id),
127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),
128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),

Line 129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),

125: DECODE (p_tran_rec.recoverable_flag, fnd_api.g_miss_char, 'N', p_tran_rec.recoverable_flag),
126: DECODE (p_tran_rec.commission_header_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_header_id),
127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),
128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),

Line 131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),

127: DECODE (p_tran_rec.commission_line_id, cn_api.g_miss_id, NULL, p_tran_rec.commission_line_id),
128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),

Line 132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),

128: DECODE (p_tran_rec.pay_element_type_id, cn_api.g_miss_id, NULL, p_tran_rec.pay_element_type_id),
129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),

Line 133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),

129: DECODE (p_tran_rec.srp_plan_assign_id, cn_api.g_miss_id, NULL, p_tran_rec.srp_plan_assign_id),
130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),

Line 134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),

130: DECODE (p_tran_rec.processed_date, fnd_api.g_miss_date, NULL, p_tran_rec.processed_date),
131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),

Line 135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),

131: DECODE (p_tran_rec.processed_period_id, cn_api.g_miss_id, NULL, p_tran_rec.processed_period_id),
132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),

Line 136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),

132: DECODE (p_tran_rec.quota_rule_id, cn_api.g_miss_id, NULL, p_tran_rec.quota_rule_id),
133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),

Line 137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),

133: DECODE (p_tran_rec.event_factor, cn_api.g_miss_num, NULL, p_tran_rec.event_factor),
134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),

Line 138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),

134: DECODE (p_tran_rec.payment_factor, cn_api.g_miss_num, NULL, p_tran_rec.payment_factor),
135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),
142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),

Line 139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),

135: DECODE (p_tran_rec.quota_factor, cn_api.g_miss_num, NULL, p_tran_rec.quota_factor),
136: DECODE (p_tran_rec.input_achieved, cn_api.g_miss_num, NULL, p_tran_rec.input_achieved),
137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),
142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),
143: DECODE (p_tran_rec.liability_ccid, cn_api.g_miss_id, NULL, p_tran_rec.liability_ccid),

Line 141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),

137: DECODE (p_tran_rec.rate_tier_id, cn_api.g_miss_id, NULL, p_tran_rec.rate_tier_id),
138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),
142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),
143: DECODE (p_tran_rec.liability_ccid, cn_api.g_miss_id, NULL, p_tran_rec.liability_ccid),
144: DECODE (p_tran_rec.attribute_category, fnd_api.g_miss_char, NULL, p_tran_rec.attribute_category),
145: DECODE (p_tran_rec.attribute1, fnd_api.g_miss_char, NULL, p_tran_rec.attribute1),

Line 142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),

138: DECODE (p_tran_rec.payee_line_id, cn_api.g_miss_id, NULL, p_tran_rec.payee_line_id),
139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),
142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),
143: DECODE (p_tran_rec.liability_ccid, cn_api.g_miss_id, NULL, p_tran_rec.liability_ccid),
144: DECODE (p_tran_rec.attribute_category, fnd_api.g_miss_char, NULL, p_tran_rec.attribute_category),
145: DECODE (p_tran_rec.attribute1, fnd_api.g_miss_char, NULL, p_tran_rec.attribute1),
146: DECODE (p_tran_rec.attribute2, fnd_api.g_miss_char, NULL, p_tran_rec.attribute2),

Line 143: DECODE (p_tran_rec.liability_ccid, cn_api.g_miss_id, NULL, p_tran_rec.liability_ccid),

139: DECODE (p_tran_rec.commission_rate, cn_api.g_miss_num, NULL, p_tran_rec.commission_rate),
140: DECODE (p_tran_rec.trx_type, fnd_api.g_miss_char, NULL, p_tran_rec.trx_type),
141: DECODE (p_tran_rec.role_id, cn_api.g_miss_id, NULL, p_tran_rec.role_id),
142: DECODE (p_tran_rec.expense_ccid, cn_api.g_miss_id, NULL, p_tran_rec.expense_ccid),
143: DECODE (p_tran_rec.liability_ccid, cn_api.g_miss_id, NULL, p_tran_rec.liability_ccid),
144: DECODE (p_tran_rec.attribute_category, fnd_api.g_miss_char, NULL, p_tran_rec.attribute_category),
145: DECODE (p_tran_rec.attribute1, fnd_api.g_miss_char, NULL, p_tran_rec.attribute1),
146: DECODE (p_tran_rec.attribute2, fnd_api.g_miss_char, NULL, p_tran_rec.attribute2),
147: DECODE (p_tran_rec.attribute3, fnd_api.g_miss_char, NULL, p_tran_rec.attribute3),

Line 208: -- Bug 2875120/2892822 : remove cn_api function call in sql statement

204: --R12
205: p_org_id IN NUMBER
206: )
207: IS
208: -- Bug 2875120/2892822 : remove cn_api function call in sql statement
209: -- Bug 2972172: Added distinct to get only one quota_id.
210: CURSOR get_quotas
211: IS
212: SELECT DISTINCT q.quota_id,

Line 461: IF cn_api.is_payee (p_salesrep_id, p_pay_period_id, p_org_id) = 1

457: AND r.org_id = p_org_id;
458: ELSE
459: -- pay by transaction
460: --Payee bug 3140343.
461: IF cn_api.is_payee (p_salesrep_id, p_pay_period_id, p_org_id) = 1
462: THEN
463: --New insert here for payee
464: INSERT INTO cn_payment_transactions
465: (payment_transaction_id,

Line 640: -- Bug 2875120 : remove cn_api function call in sql statement

636: 'N',
637: 'N',
638: p_payrun_id,
639: NVL (cl.commission_amount, 0),
640: -- Bug 2875120 : remove cn_api function call in sql statement
641: DECODE (l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
642: SYSDATE,
643: fnd_global.user_id,
644: SYSDATE,