APPS.XTR_HEDGE_POLICIES_PKG dependencies on XTR_HEDGE_POLICIES

Line 1: package body XTR_HEDGE_POLICIES_PKG as

1: package body XTR_HEDGE_POLICIES_PKG as
2: /* $Header: xtrhpolb.pls 120.4 2005/06/29 08:18:55 badiredd ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_HEDGE_POLICY_ID in NUMBER,

Line 16: cursor C is select ROWID from XTR_HEDGE_POLICIES

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from XTR_HEDGE_POLICIES
17: where HEDGE_POLICY_ID = X_HEDGE_POLICY_ID;
18: begin
19: insert into XTR_HEDGE_POLICIES (
20: HEDGE_POLICY_ID,

Line 19: insert into XTR_HEDGE_POLICIES (

15: ) is
16: cursor C is select ROWID from XTR_HEDGE_POLICIES
17: where HEDGE_POLICY_ID = X_HEDGE_POLICY_ID;
18: begin
19: insert into XTR_HEDGE_POLICIES (
20: HEDGE_POLICY_ID,
21: SOURCE_TYPE_ID,
22: CASHFLOW_FLAG,
23: FAIRVALUE_FLAG,

Line 65: from XTR_HEDGE_POLICIES

61: CASHFLOW_FLAG,
62: FAIRVALUE_FLAG,
63: ECONOMIC_FLAG,
64: HEDGE_POLICY_ID
65: from XTR_HEDGE_POLICIES
66: where HEDGE_POLICY_ID = X_HEDGE_POLICY_ID
67: for update of HEDGE_POLICY_ID nowait;
68: begin
69: for tlinfo in c1 loop

Line 99: update XTR_HEDGE_POLICIES set

95: X_LAST_UPDATED_BY in NUMBER,
96: X_LAST_UPDATE_LOGIN in NUMBER
97: ) is
98: begin
99: update XTR_HEDGE_POLICIES set
100: SOURCE_TYPE_ID = X_SOURCE_TYPE_ID,
101: CASHFLOW_FLAG = X_CASHFLOW_FLAG,
102: FAIRVALUE_FLAG = X_FAIRVALUE_FLAG,
103: ECONOMIC_FLAG = X_ECONOMIC_FLAG,

Line 118: delete from XTR_HEDGE_POLICIES

114: procedure DELETE_ROW (
115: X_HEDGE_POLICY_ID in NUMBER
116: ) is
117: begin
118: delete from XTR_HEDGE_POLICIES
119: where HEDGE_POLICY_ID = X_HEDGE_POLICY_ID;
120:
121: if (sql%notfound) then
122: raise no_data_found;