APPS.XNP_SV_STATUS_TYPES_PKG dependencies on XNP_SV_STATUS_TYPES_B

Line 19: cursor C is select ROWID from XNP_SV_STATUS_TYPES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from XNP_SV_STATUS_TYPES_B
20: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE
21: ;
22: begin
23: insert into XNP_SV_STATUS_TYPES_B (

Line 23: insert into XNP_SV_STATUS_TYPES_B (

19: cursor C is select ROWID from XNP_SV_STATUS_TYPES_B
20: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE
21: ;
22: begin
23: insert into XNP_SV_STATUS_TYPES_B (
24: STATUS_TYPE_CODE,
25: PHASE_INDICATOR,
26: ACTIVE_FLAG,
27: INITIAL_FLAG,

Line 105: from XNP_SV_STATUS_TYPES_B

101: ACTIVE_FLAG,
102: INITIAL_FLAG,
103: INITIAL_FLAG_ENFORCE_SEQ,
104: DISPLAY_SEQUENCE
105: from XNP_SV_STATUS_TYPES_B
106: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE
107: for update of STATUS_TYPE_CODE nowait;
108: recinfo c%rowtype;
109:

Line 169: update XNP_SV_STATUS_TYPES_B set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update XNP_SV_STATUS_TYPES_B set
170: PHASE_INDICATOR = X_PHASE_INDICATOR,
171: ACTIVE_FLAG = X_ACTIVE_FLAG,
172: INITIAL_FLAG = X_INITIAL_FLAG,
173: INITIAL_FLAG_ENFORCE_SEQ = X_INITIAL_FLAG_ENFORCE_SEQ,

Line 210: delete from XNP_SV_STATUS_TYPES_B

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: delete from XNP_SV_STATUS_TYPES_B
211: where STATUS_TYPE_CODE = X_STATUS_TYPE_CODE;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 224: from XNP_SV_STATUS_TYPES_B B

220: begin
221: delete from XNP_SV_STATUS_TYPES_TL T
222: where not exists
223: (select NULL
224: from XNP_SV_STATUS_TYPES_B B
225: where B.STATUS_TYPE_CODE = T.STATUS_TYPE_CODE
226: );
227:
228: update XNP_SV_STATUS_TYPES_TL T set (