APPS.IGS_AS_UNT_PATRN_ITM_PKG dependencies on IGS_AS_UNT_PATRN_ITM

Line 1: package body IGS_AS_UNT_PATRN_ITM_PKG as

1: package body IGS_AS_UNT_PATRN_ITM_PKG as
2: /* $Header: IGSDI32B.pls 120.0 2005/07/05 13:00:43 appldev noship $ */
3:
4: --
5:

Line 7: old_references IGS_AS_UNT_PATRN_ITM%RowType;

3:
4: --
5:
6: l_rowid VARCHAR2(25);
7: old_references IGS_AS_UNT_PATRN_ITM%RowType;
8: new_references IGS_AS_UNT_PATRN_ITM%RowType;
9:
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,

Line 8: new_references IGS_AS_UNT_PATRN_ITM%RowType;

4: --
5:
6: l_rowid VARCHAR2(25);
7: old_references IGS_AS_UNT_PATRN_ITM%RowType;
8: new_references IGS_AS_UNT_PATRN_ITM%RowType;
9:
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,
12: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 30: FROM IGS_AS_UNT_PATRN_ITM

26: ) as
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_AS_UNT_PATRN_ITM
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 75: -- ON IGS_AS_UNT_PATRN_ITM

71:
72: -- Trigger description :-
73: -- "OSS_TST".trg_uapi_br_id
74: -- BEFORE INSERT OR DELETE
75: -- ON IGS_AS_UNT_PATRN_ITM
76: -- FOR EACH ROW
77:
78: PROCEDURE BeforeRowInsertDelete1(
79: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 278: FROM IGS_AS_UNT_PATRN_ITM

274: x_uai_sequence_number IN NUMBER
275: ) RETURN BOOLEAN AS
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM IGS_AS_UNT_PATRN_ITM
279: WHERE unit_cd = x_unit_cd
280: AND version_number = x_version_number
281: AND cal_type= x_cal_type
282: AND ci_sequence_number = x_ci_sequence_number

Line 315: FROM IGS_AS_UNT_PATRN_ITM

311: ) as
312:
313: CURSOR cur_rowid IS
314: SELECT rowid
315: FROM IGS_AS_UNT_PATRN_ITM
316: WHERE unit_cd = x_unit_cd
317: AND version_number = x_version_number
318: AND cal_type= x_cal_type
319: AND ci_sequence_number = x_ci_sequence_number

Line 350: FROM IGS_AS_UNT_PATRN_ITM

346: ) as
347:
348: CURSOR cur_rowid IS
349: SELECT rowid
350: FROM IGS_AS_UNT_PATRN_ITM
351: WHERE unit_cd = x_unit_cd
352: AND version_number = x_version_number
353: AND cal_type= x_cal_type
354: AND ci_sequence_number = x_ci_sequence_number

Line 473: cursor C is select ROWID from IGS_AS_UNT_PATRN_ITM

469: X_UAI_SEQUENCE_NUMBER in NUMBER,
470: X_APPORTIONMENT_PERCENTAGE in NUMBER,
471: X_MODE in VARCHAR2 default 'R'
472: ) as
473: cursor C is select ROWID from IGS_AS_UNT_PATRN_ITM
474: where UNIT_CD = X_UNIT_CD
475: and VERSION_NUMBER = X_VERSION_NUMBER
476: and CAL_TYPE = X_CAL_TYPE
477: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 539: insert into IGS_AS_UNT_PATRN_ITM (

535: x_last_updated_by=>X_LAST_UPDATED_BY,
536: x_last_update_login=>X_LAST_UPDATE_LOGIN
537: );
538: --
539: insert into IGS_AS_UNT_PATRN_ITM (
540: UNIT_CD,
541: VERSION_NUMBER,
542: CAL_TYPE,
543: CI_SEQUENCE_NUMBER,

Line 603: from IGS_AS_UNT_PATRN_ITM

599: X_APPORTIONMENT_PERCENTAGE in NUMBER
600: ) as
601: cursor c1 is select
602: APPORTIONMENT_PERCENTAGE
603: from IGS_AS_UNT_PATRN_ITM
604: where ROWID = X_ROWID for update nowait;
605: tlinfo c1%rowtype;
606:
607: begin

Line 704: update IGS_AS_UNT_PATRN_ITM set

700: --
701:
702: --
703: end if;
704: update IGS_AS_UNT_PATRN_ITM set
705: APPORTIONMENT_PERCENTAGE = NEW_REFERENCES.APPORTIONMENT_PERCENTAGE,
706: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
707: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
708: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 733: cursor c1 is select rowid from IGS_AS_UNT_PATRN_ITM

729: X_UAI_SEQUENCE_NUMBER in NUMBER,
730: X_APPORTIONMENT_PERCENTAGE in NUMBER,
731: X_MODE in VARCHAR2 default 'R'
732: ) as
733: cursor c1 is select rowid from IGS_AS_UNT_PATRN_ITM
734: where UNIT_CD = X_UNIT_CD
735: and VERSION_NUMBER = X_VERSION_NUMBER
736: and CAL_TYPE = X_CAL_TYPE
737: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 783: delete from IGS_AS_UNT_PATRN_ITM

779: p_action => 'DELETE',
780: x_rowid => X_ROWID
781: );
782: --
783: delete from IGS_AS_UNT_PATRN_ITM
784: where ROWID = X_ROWID;
785: if (sql%notfound) then
786: raise no_data_found;
787: end if;

Line 792: end IGS_AS_UNT_PATRN_ITM_PKG;

788: --
789: --
790: end DELETE_ROW;
791:
792: end IGS_AS_UNT_PATRN_ITM_PKG;