APPS.CN_SRP_TOTAL_COMPS_PKG dependencies on CN_SRP_TOTAL_COMPS_S

Line 5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,

1: PACKAGE BODY CN_SRP_TOTAL_COMPS_pkg AS
2: /*$Header: cntmotcb.pls 115.3 2002/01/28 20:04:57 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,

Line 6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,

2: /*$Header: cntmotcb.pls 115.3 2002/01/28 20:04:57 pkm ship $*/
3:
4: PROCEDURE insert_row
5: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
6: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
7: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE := NULL,
8: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
9: p_role_id IN cn_srp_total_comps.role_id%TYPE,
10: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,

Line 73: cn_srp_total_comps_s.nextval,

69: LAST_UPDATED_BY,
70: object_version_number
71: )
72: SELECT
73: cn_srp_total_comps_s.nextval,
74: p_srp_role_id,
75: p_role_model_id,
76: decode(p_role_id,mn,null,p_role_id),
77: decode(p_attain_tier_id,mn,null,p_attain_tier_id),

Line 108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,

104: END insert_row;
105:
106:
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,

Line 109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,

105:
106:
107: PROCEDURE update_row
108: (p_SRP_TOTAL_COMP_ID IN cn_srp_total_comps.SRP_TOTAL_COMP_ID%TYPE,
109: p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE,
110: p_role_model_id IN cn_srp_total_comps.role_model_id%TYPE :=NULL,
111: p_attain_tier_id IN cn_srp_total_comps.attain_tier_id%TYPE,
112: p_role_id IN cn_srp_total_comps.role_id%TYPE,
113: p_attain_schedule_id IN cn_srp_total_comps.attain_schedule_id%TYPE,

Line 168: UPDATE cn_srp_total_comps SET

164: fnd_msg_pub.add;
165: raise fnd_api.g_exc_error;
166: END IF;
167:
168: UPDATE cn_srp_total_comps SET
169: (percent,
170: total_comp,
171: attribute_category,
172: attribute1,

Line 223: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE) IS

219: END update_row;
220:
221:
222: PROCEDURE delete_row
223: (p_srp_role_id IN cn_srp_total_comps.srp_role_id%TYPE) IS
224: BEGIN
225: DELETE FROM cn_srp_total_comps
226: WHERE srp_role_id = p_srp_role_id;
227: