APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_DC_DISTRIBUTORS

Line 149: | Procedure populates the zpb_dc_distributors table to keep

145: /*=========================================================================+
146: | PROCEDURE Populate_Distributors
147: |
148: | DESCRIPTION
149: | Procedure populates the zpb_dc_distributors table to keep
150: | track of the distributors for a specific worksheet.
151: |
152: +=========================================================================*/
153:

Line 161: INSERT INTO ZPB_DC_DISTRIBUTORS(

157: p_distributor_user_id IN NUMBER ,
158: p_approver_type IN VARCHAR2
159: ) IS
160: BEGIN
161: INSERT INTO ZPB_DC_DISTRIBUTORS(
162: OBJECT_ID,
163: DISTRIBUTOR_USER_ID,
164: DISTRIBUTION_DATE,
165: APPROVER_TYPE,

Line 575: UPDATE ZPB_DC_DISTRIBUTORS

571: p_business_area_id,
572: p_multiple_submissions_flag);
573: ELSE -- update
574: -- Update distributors table
575: UPDATE ZPB_DC_DISTRIBUTORS
576: SET DISTRIBUTION_DATE = SYSDATE,
577: APPROVER_TYPE = l_approver_type,
578: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID,
579: LAST_UPDATED_BY = fnd_global.user_id,