APPS.IGS_AD_PRD_AD_PRC_CA_PKG dependencies on IGS_AD_PRD_AD_PRC_CA

Line 1: PACKAGE BODY IGS_AD_PRD_AD_PRC_CA_PKG AS

1: PACKAGE BODY IGS_AD_PRD_AD_PRC_CA_PKG AS
2: /* $Header: IGSAI30B.pls 115.8 2003/10/30 13:12:17 akadam ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_AD_PRC_CA%RowType;
5: new_references IGS_AD_PRD_AD_PRC_CA%RowType;

Line 4: old_references IGS_AD_PRD_AD_PRC_CA%RowType;

1: PACKAGE BODY IGS_AD_PRD_AD_PRC_CA_PKG AS
2: /* $Header: IGSAI30B.pls 115.8 2003/10/30 13:12:17 akadam ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_AD_PRC_CA%RowType;
5: new_references IGS_AD_PRD_AD_PRC_CA%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PRD_AD_PRC_CA%RowType;

1: PACKAGE BODY IGS_AD_PRD_AD_PRC_CA_PKG AS
2: /* $Header: IGSAI30B.pls 115.8 2003/10/30 13:12:17 akadam ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PRD_AD_PRC_CA%RowType;
5: new_references IGS_AD_PRD_AD_PRC_CA%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 26: FROM IGS_AD_PRD_AD_PRC_CA

22: ) AS
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AD_PRD_AD_PRC_CA
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 167: IGS_AD_APPL_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (

163:
164: PROCEDURE Check_Child_Existance AS
165: BEGIN
166:
167: IGS_AD_APPL_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (
168: old_references.adm_cal_type,
169: old_references.adm_ci_sequence_number,
170: old_references.admission_cat,
171: old_references.s_admission_process_type

Line 174: IGS_AD_PRD_PS_OF_OPT_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (

170: old_references.admission_cat,
171: old_references.s_admission_process_type
172: );
173:
174: IGS_AD_PRD_PS_OF_OPT_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (
175: old_references.adm_cal_type,
176: old_references.adm_ci_sequence_number,
177: old_references.admission_cat,
178: old_references.s_admission_process_type

Line 181: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (

177: old_references.admission_cat,
178: old_references.s_admission_process_type
179: );
180:
181: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_AD_PRD_AD_PRC_CA (
182: old_references.adm_cal_type,
183: old_references.adm_ci_sequence_number,
184: old_references.admission_cat,
185: old_references.s_admission_process_type

Line 201: FROM IGS_AD_PRD_AD_PRC_CA

197: RETURN BOOLEAN
198: AS
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_AD_PRD_AD_PRC_CA
202: WHERE adm_cal_type = x_adm_cal_type
203: AND adm_ci_sequence_number = x_adm_ci_sequence_number
204: AND admission_cat = x_admission_cat
205: AND s_admission_process_type = x_s_admission_process_type AND

Line 231: FROM IGS_AD_PRD_AD_PRC_CA

227: ) AS
228:
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM IGS_AD_PRD_AD_PRC_CA
232: WHERE adm_cal_type = x_adm_cal_type
233: AND adm_ci_sequence_number = x_adm_ci_sequence_number
234: AND admission_cat = x_admission_cat ;
235:

Line 260: FROM IGS_AD_PRD_AD_PRC_CA

256: ) AS
257:
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM IGS_AD_PRD_AD_PRC_CA
261: WHERE admission_cat = x_admission_cat
262: AND s_admission_process_type = x_s_admission_process_type ;
263:
264: lv_rowid cur_rowid%RowType;

Line 389: cursor C is select ROWID from IGS_AD_PRD_AD_PRC_CA

385: x_closed_ind IN VARCHAR2,
386: x_single_response_flag IN VARCHAR2,
387: x_include_sr_in_rollover_flag IN VARCHAR2
388: ) AS
389: cursor C is select ROWID from IGS_AD_PRD_AD_PRC_CA
390: where ADM_CAL_TYPE = X_ADM_CAL_TYPE
391: and ADM_CI_SEQUENCE_NUMBER = X_ADM_CI_SEQUENCE_NUMBER
392: and ADMISSION_CAT = X_ADMISSION_CAT
393: and S_ADMISSION_PROCESS_TYPE = X_S_ADMISSION_PROCESS_TYPE;

Line 432: INSERT INTO IGS_AD_PRD_AD_PRC_CA (

428: x_single_response_flag => x_single_response_flag,
429: x_include_sr_in_rollover_flag => x_include_sr_in_rollover_flag
430: );
431:
432: INSERT INTO IGS_AD_PRD_AD_PRC_CA (
433: ADM_CAL_TYPE,
434: ADM_CI_SEQUENCE_NUMBER,
435: ADMISSION_CAT,
436: S_ADMISSION_PROCESS_TYPE,

Line 523: UPDATE IGS_AD_PRD_AD_PRC_CA SET

519: x_single_response_flag => x_single_response_flag,
520: x_include_sr_in_rollover_flag => x_include_sr_in_rollover_flag
521: );
522:
523: UPDATE IGS_AD_PRD_AD_PRC_CA SET
524: ADM_CAL_TYPE = new_references.adm_cal_type,
525: ADM_CI_SEQUENCE_NUMBER = new_references.adm_ci_sequence_number,
526: ADMISSION_CAT = new_references.admission_cat,
527: S_ADMISSION_PROCESS_TYPE = new_references.s_admission_process_type,

Line 559: FROM IGS_AD_PRD_AD_PRC_CA

555: x_include_sr_in_rollover_flag IN VARCHAR2
556: ) AS
557: CURSOR c1 IS SELECT
558: rowid
559: FROM IGS_AD_PRD_AD_PRC_CA
560: WHERE ROWID = X_ROWID for update nowait;
561: tlinfo c1%rowtype;
562:
563: BEGIN

Line 585: DELETE FROM IGS_AD_PRD_AD_PRC_CA

581: Before_DML(
582: p_action =>'DELETE',
583: x_rowid => X_ROWID
584: );
585: DELETE FROM IGS_AD_PRD_AD_PRC_CA
586: WHERE ROWID = X_ROWID;
587: IF (sql%notfound) then
588: raise no_data_found;
589: END IF;

Line 597: END IGS_AD_PRD_AD_PRC_CA_PKG;

593: );
594:
595: END DELETE_ROW;
596:
597: END IGS_AD_PRD_AD_PRC_CA_PKG;