APPS.CS_PARTY_ROLES_PKG dependencies on CS_PARTY_ROLES_B

Line 20: insert into CS_PARTY_ROLES_B (

16: X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
17: ) is
18: l_object_version_number NUMBER := 1;
19: begin
20: insert into CS_PARTY_ROLES_B (
21: PARTY_ROLE_CODE,
22: START_DATE_ACTIVE,
23: END_DATE_ACTIVE,
24: SEEDED_FLAG,

Line 94: update CS_PARTY_ROLES_B set

90: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
91: ) is
92: l_object_Version_number number;
93: begin
94: update CS_PARTY_ROLES_B set
95: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
96: END_DATE_ACTIVE = P_END_DATE_ACTIVE,
97: SEEDED_FLAG = P_SEEDED_FLAG,
98: SORT_ORDER = P_SORT_ORDER,

Line 138: delete from CS_PARTY_ROLES_B

134: if (sql%notfound) then
135: raise no_data_found;
136: end if;
137:
138: delete from CS_PARTY_ROLES_B
139: where PARTY_ROLE_CODE = P_PARTY_ROLE_CODE;
140:
141: if (sql%notfound) then
142: raise no_data_found;

Line 152: from CS_PARTY_ROLES_B B

148: begin
149: delete from CS_PARTY_ROLES_TL T
150: where not exists
151: (select NULL
152: from CS_PARTY_ROLES_B B
153: where B.PARTY_ROLE_CODE = T.PARTY_ROLE_CODE
154: );
155:
156: update CS_PARTY_ROLES_TL T set (