DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_USERS

Line 773: insert into ZPB_BUSAREA_USERS

769: FND_GLOBAL.LOGIN_ID,
770: sysdate,
771: FND_GLOBAL.USER_ID);
772:
773: insert into ZPB_BUSAREA_USERS
774: (BUSINESS_AREA_ID,
775: USER_ID,
776: CREATION_DATE,
777: CREATED_BY,

Line 1530: delete from ZPB_BUSAREA_USERS

1526:
1527: delete from ZPB_USERS
1528: where BUSINESS_AREA_ID = p_business_area_id;
1529:
1530: delete from ZPB_BUSAREA_USERS
1531: where BUSINESS_AREA_ID = p_business_area_id;
1532:
1533: delete from ZPB_BUSINESS_AREAS
1534: where BUSINESS_AREA_ID = p_business_area_id;

Line 1904: insert into ZPB_BUSAREA_USERS

1900: PROCEDURE ADD_USER (p_business_area_id IN NUMBER,
1901: p_user_id IN NUMBER)
1902: is
1903: begin
1904: insert into ZPB_BUSAREA_USERS
1905: (BUSINESS_AREA_ID,
1906: USER_ID,
1907: CREATION_DATE,
1908: CREATED_BY,

Line 1933: delete from ZPB_BUSAREA_USERS

1929: PROCEDURE REMOVE_USER (p_business_area_id IN NUMBER,
1930: p_user_id IN NUMBER)
1931: is
1932: begin
1933: delete from ZPB_BUSAREA_USERS
1934: where BUSINESS_AREA_ID = p_business_area_id
1935: and USER_ID = p_user_id;
1936: end REMOVE_USER;
1937: