APPS.CN_PAYRUNS_PKG dependencies on CN_API

Line 110: x_pay_period_id cn_payruns.pay_period_id%TYPE := cn_api.g_miss_id,

106: -- ===========================================================================
107: PROCEDURE UPDATE_RECORD (
108: x_payrun_id cn_payruns.payrun_id%TYPE,
109: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
110: x_pay_period_id cn_payruns.pay_period_id%TYPE := cn_api.g_miss_id,
111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,
112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,
113: x_pay_date cn_payruns.pay_date%TYPE := fnd_api.g_miss_date,
114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,

Line 111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,

107: PROCEDURE UPDATE_RECORD (
108: x_payrun_id cn_payruns.payrun_id%TYPE,
109: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
110: x_pay_period_id cn_payruns.pay_period_id%TYPE := cn_api.g_miss_id,
111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,
112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,
113: x_pay_date cn_payruns.pay_date%TYPE := fnd_api.g_miss_date,
114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,
115: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,

Line 112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,

108: x_payrun_id cn_payruns.payrun_id%TYPE,
109: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
110: x_pay_period_id cn_payruns.pay_period_id%TYPE := cn_api.g_miss_id,
111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,
112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,
113: x_pay_date cn_payruns.pay_date%TYPE := fnd_api.g_miss_date,
114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,
115: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
116: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,

Line 114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,

110: x_pay_period_id cn_payruns.pay_period_id%TYPE := cn_api.g_miss_id,
111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,
112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,
113: x_pay_date cn_payruns.pay_date%TYPE := fnd_api.g_miss_date,
114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,
115: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
116: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
117: x_last_updated_by cn_payruns.last_updated_by%TYPE,
118: x_last_update_date cn_payruns.last_update_date%TYPE,

Line 115: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,

111: x_incentive_type_code cn_payruns.incentive_type_code%TYPE := cn_api.g_miss_char,
112: x_pay_group_id cn_payruns.pay_group_id%TYPE := cn_api.g_miss_id,
113: x_pay_date cn_payruns.pay_date%TYPE := fnd_api.g_miss_date,
114: x_accounting_period_id cn_payruns.accounting_period_id%TYPE := cn_api.g_miss_id,
115: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
116: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
117: x_last_updated_by cn_payruns.last_updated_by%TYPE,
118: x_last_update_date cn_payruns.last_update_date%TYPE,
119: x_last_update_login cn_payruns.last_update_login%TYPE,

Line 148: DECODE (x_pay_period_id, cn_api.g_miss_id, l_payrun_rec.pay_period_id, x_pay_period_id),

144:
145: CLOSE payrun_cur;
146:
147: SELECT DECODE (x_name, fnd_api.g_miss_char, l_payrun_rec.NAME, x_name),
148: DECODE (x_pay_period_id, cn_api.g_miss_id, l_payrun_rec.pay_period_id, x_pay_period_id),
149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),
150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),
151: DECODE (x_pay_date, fnd_api.g_miss_date, l_payrun_rec.pay_date, x_pay_date),
152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),

Line 149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),

145: CLOSE payrun_cur;
146:
147: SELECT DECODE (x_name, fnd_api.g_miss_char, l_payrun_rec.NAME, x_name),
148: DECODE (x_pay_period_id, cn_api.g_miss_id, l_payrun_rec.pay_period_id, x_pay_period_id),
149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),
150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),
151: DECODE (x_pay_date, fnd_api.g_miss_date, l_payrun_rec.pay_date, x_pay_date),
152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),
153: DECODE (x_batch_id, cn_api.g_miss_id, l_payrun_rec.batch_id, x_batch_id),

Line 150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),

146:
147: SELECT DECODE (x_name, fnd_api.g_miss_char, l_payrun_rec.NAME, x_name),
148: DECODE (x_pay_period_id, cn_api.g_miss_id, l_payrun_rec.pay_period_id, x_pay_period_id),
149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),
150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),
151: DECODE (x_pay_date, fnd_api.g_miss_date, l_payrun_rec.pay_date, x_pay_date),
152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),
153: DECODE (x_batch_id, cn_api.g_miss_id, l_payrun_rec.batch_id, x_batch_id),
154: DECODE (x_status, fnd_api.g_miss_char, l_payrun_rec.status, x_status)

Line 152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),

148: DECODE (x_pay_period_id, cn_api.g_miss_id, l_payrun_rec.pay_period_id, x_pay_period_id),
149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),
150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),
151: DECODE (x_pay_date, fnd_api.g_miss_date, l_payrun_rec.pay_date, x_pay_date),
152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),
153: DECODE (x_batch_id, cn_api.g_miss_id, l_payrun_rec.batch_id, x_batch_id),
154: DECODE (x_status, fnd_api.g_miss_char, l_payrun_rec.status, x_status)
155: INTO l_name,
156: l_pay_period_id,

Line 153: DECODE (x_batch_id, cn_api.g_miss_id, l_payrun_rec.batch_id, x_batch_id),

149: DECODE (x_incentive_type_code, cn_api.g_miss_char, l_payrun_rec.incentive_type_code, x_incentive_type_code),
150: DECODE (x_pay_group_id, cn_api.g_miss_id, l_payrun_rec.pay_group_id, x_pay_group_id),
151: DECODE (x_pay_date, fnd_api.g_miss_date, l_payrun_rec.pay_date, x_pay_date),
152: DECODE (x_accounting_period_id, cn_api.g_miss_id, l_payrun_rec.accounting_period_id, x_accounting_period_id),
153: DECODE (x_batch_id, cn_api.g_miss_id, l_payrun_rec.batch_id, x_batch_id),
154: DECODE (x_status, fnd_api.g_miss_char, l_payrun_rec.status, x_status)
155: INTO l_name,
156: l_pay_period_id,
157: l_incentive_type_code,