APPS.CN_SRP_PAYOUT_DTLS_PKG dependencies on CN_SRP_PAYOUT_DTLS_S

Line 5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

1: PACKAGE BODY CN_SRP_PAYOUT_DTLS_PKG AS
2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

2: /*$Header: cntmdtlb.pls 115.0 2003/08/25 21:47:57 nkodkani noship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
6: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

Line 76: cn_srp_payout_dtls_s.nextval,

72: LAST_UPDATED_BY,
73: object_version_number
74: )
75: SELECT
76: cn_srp_payout_dtls_s.nextval,
77: p_srp_role_id,
78: p_role_model_id,
79: decode(p_role_id,mn,null,p_role_id),
80: decode(p_attain_tier_id,mn,null,p_attain_tier_id),

Line 113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,

109: END insert_row;
110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,

Line 114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,

110:
111:
112: PROCEDURE update_row
113: (p_SRP_payout_dtl_ID IN cn_srp_payout_dtls.SRP_payout_dtl_ID%TYPE,
114: p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE,
115: p_role_model_id IN cn_srp_payout_dtls.role_model_id%TYPE :=NULL,
116: p_attain_tier_id IN cn_srp_payout_dtls.attain_tier_id%TYPE,
117: p_role_id IN cn_srp_payout_dtls.role_id%TYPE,
118: p_attain_schedule_id IN cn_srp_payout_dtls.attain_schedule_id%TYPE,

Line 174: UPDATE cn_srp_payout_dtls SET

170: fnd_msg_pub.add;
171: raise fnd_api.g_exc_error;
172: END IF;
173:
174: UPDATE cn_srp_payout_dtls SET
175: (percent,
176: payout,
177: quota_category_id,
178: attribute_category,

Line 231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS

227: END update_row;
228:
229:
230: PROCEDURE delete_row
231: (p_srp_role_id IN cn_srp_payout_dtls.srp_role_id%TYPE) IS
232: BEGIN
233: DELETE FROM cn_srp_payout_dtls
234: WHERE srp_role_id = p_srp_role_id;
235: