APPS.CN_SRP_PLAN_ASSIGNS_PKG dependencies on CN_SRP_PLAN_ASSIGNS_S

Line 27: SELECT cn_srp_plan_assigns_s.nextval

23: -- Get the Sequence Number to Create a new Srp Plan Assign.
24: -- -------------------------------------------------------------------------+
25: PROCEDURE Get_UID( X_srp_plan_assign_id IN OUT NOCOPY NUMBER) IS
26: BEGIN
27: SELECT cn_srp_plan_assigns_s.nextval
28: INTO x_srp_plan_assign_id
29: FROM dual;
30: END Get_UID;
31:

Line 335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;

331: X_LAST_UPDATED_BY IN NUMBER,
332: X_LAST_UPDATE_LOGIN IN NUMBER
333: ) IS
334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;

Line 337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;

333: ) IS
334:
335: l_srp_role_id CN_SRP_PLAN_ASSIGNS.srp_role_id%TYPE;
336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;

Line 340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;

336: l_role_plan_id CN_SRP_PLAN_ASSIGNS.role_plan_id%TYPE;
337: l_salesrep_id CN_SRP_PLAN_ASSIGNS.salesrep_id%TYPE;
338: l_role_id CN_SRP_PLAN_ASSIGNS.role_id%TYPE;
339: l_comp_plan_id CN_SRP_PLAN_ASSIGNS.comp_plan_id%TYPE;
340: l_start_date CN_SRP_PLAN_ASSIGNS.start_date%TYPE;
341: l_end_date CN_SRP_PLAN_ASSIGNS.end_date%TYPE;
342: l_attribute_category CN_SRP_PLAN_ASSIGNS.attribute_category%TYPE;
343: l_attribute1 CN_SRP_PLAN_ASSIGNS.attribute1%TYPE;
344: l_attribute2 CN_SRP_PLAN_ASSIGNS.attribute2%TYPE;