DBA Data[Home] [Help]

APPS.CS_PARTY_ROLE_GROUP_MAPS_PKG dependencies on CS_PARTY_ROLE_GROUP_MAPS

Line 1: package body CS_PARTY_ROLE_GROUP_MAPS_PKG as

1: package body CS_PARTY_ROLE_GROUP_MAPS_PKG as
2: /* $Header: csptyrgb.pls 120.0 2005/08/18 19:24 aneemuch noship $ */
3: procedure INSERT_ROW (
4: PX_PARTY_ROLE_GROUP_MAPPING_ID in out NOCOPY NUMBER,
5: PX_PARTY_ROLE_GROUP_CODE in out NOCOPY VARCHAR2,

Line 19: insert into CS_PARTY_ROLE_GROUP_MAPS (

15: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
16: ) is
17: l_object_Version_number number := 1;
18: begin
19: insert into CS_PARTY_ROLE_GROUP_MAPS (
20: PARTY_ROLE_GROUP_MAPPING_ID,
21: PARTY_ROLE_GROUP_CODE,
22: PARTY_ROLE_CODE,
23: SEEDED_FLAG,

Line 64: update CS_PARTY_ROLE_GROUP_MAPS set

60: P_LAST_UPDATE_LOGIN in NUMBER,
61: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
62: ) is
63: begin
64: update CS_PARTY_ROLE_GROUP_MAPS set
65: SEEDED_FLAG = P_SEEDED_FLAG,
66: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
67: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
68: END_DATE_ACTIVE = P_END_DATE_ACTIVE,

Line 88: delete from CS_PARTY_ROLE_GROUP_MAPS

84: P_PARTY_ROLE_GROUP_CODE in VARCHAR2,
85: P_PARTY_ROLE_CODE in VARCHAR2
86: ) is
87: begin
88: delete from CS_PARTY_ROLE_GROUP_MAPS
89: where PARTY_ROLE_GROUP_CODE = P_PARTY_ROLE_GROUP_CODE
90: and PARTY_ROLE_CODE = P_PARTY_ROLE_CODE;
91:
92: if (sql%notfound) then

Line 169: end CS_PARTY_ROLE_GROUP_MAPS_PKG;

165: );
166:
167: END LOAD_ROW;
168:
169: end CS_PARTY_ROLE_GROUP_MAPS_PKG;