APPS.PO_ASL_AUTHORIZATIONS_THS dependencies on CHV_AUTHORIZATIONS

Line 26: FROM CHV_AUTHORIZATIONS

22: x_timefence_days NUMBER,
23: x_rowid IN OUT NOCOPY VARCHAR2) is
24:
25: cursor row_id is SELECT rowid
26: FROM CHV_AUTHORIZATIONS
27: WHERE reference_id = x_reference_id
28: AND reference_type = x_reference_type
29: AND using_organization_id = x_using_organization_id
30: AND authorization_sequence = x_authorization_sequence;

Line 54: INSERT INTO CHV_AUTHORIZATIONS(

50: app_exception.raise_exception;
51:
52: END IF;
53:
54: INSERT INTO CHV_AUTHORIZATIONS(
55: using_organization_id ,
56: reference_id ,
57: reference_type ,
58: authorization_code ,

Line 114: UPDATE CHV_AUTHORIZATIONS

110: x_timefence_days NUMBER,
111: x_rowid VARCHAR2) is
112: begin
113:
114: UPDATE CHV_AUTHORIZATIONS
115: SET
116: using_organization_id = x_using_organization_id ,
117: reference_id = x_reference_id ,
118: reference_type = x_reference_type ,

Line 153: FROM CHV_AUTHORIZATIONS

149: x_timefence_days NUMBER,
150: x_rowid VARCHAR2) is
151:
152: cursor auth_row is SELECT *
153: FROM CHV_AUTHORIZATIONS
154: WHERE rowid = x_rowid
155: FOR UPDATE NOWAIT;
156:
157: recinfo auth_row%rowtype;