APPS.XDP_FA_PARAMETERS_PKG dependencies on XDP_FA_PARAMETERS

Line 1: package body XDP_FA_PARAMETERS_PKG as

1: package body XDP_FA_PARAMETERS_PKG as
2: /* $Header: XDPFAPRB.pls 120.1 2005/06/15 22:59:39 appldev $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FULFILLMENT_ACTION_ID in NUMBER,

Line 18: cursor C is select ROWID from XDP_FA_PARAMETERS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from XDP_FA_PARAMETERS
19: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
20: and PARAMETER_NAME = X_PARAMETER_NAME;
21: begin
22: insert into XDP_FA_PARAMETERS (

Line 22: insert into XDP_FA_PARAMETERS (

18: cursor C is select ROWID from XDP_FA_PARAMETERS
19: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
20: and PARAMETER_NAME = X_PARAMETER_NAME;
21: begin
22: insert into XDP_FA_PARAMETERS (
23: FULFILLMENT_ACTION_ID,
24: PARAMETER_NAME,
25: EVALUATION_PROCEDURE,
26: EVALUATION_SEQ,

Line 74: from XDP_FA_PARAMETERS

70: EVALUATION_SEQ,
71: LOG_IN_AUDIT_TRAIL_FLAG,
72: DISPLAY_SEQ,
73: DEFAULT_VALUE
74: from XDP_FA_PARAMETERS
75: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
76: and PARAMETER_NAME = X_PARAMETER_NAME
77: for update of FULFILLMENT_ACTION_ID nowait;
78: begin

Line 113: update XDP_FA_PARAMETERS set

109: X_LAST_UPDATED_BY in NUMBER,
110: X_LAST_UPDATE_LOGIN in NUMBER
111: ) is
112: begin
113: update XDP_FA_PARAMETERS set
114: EVALUATION_PROCEDURE = X_EVALUATION_PROCEDURE,
115: EVALUATION_SEQ = X_EVALUATION_SEQ,
116: LOG_IN_AUDIT_TRAIL_FLAG = X_LOG_IN_AUDIT_TRAIL_FLAG,
117: DISPLAY_SEQ = X_DISPLAY_SEQ,

Line 135: delete from XDP_FA_PARAMETERS

131: X_FULFILLMENT_ACTION_ID in NUMBER,
132: X_PARAMETER_NAME in VARCHAR2
133: ) is
134: begin
135: delete from XDP_FA_PARAMETERS
136: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
137: and PARAMETER_NAME = X_PARAMETER_NAME ;
138:
139: if (sql%notfound) then

Line 145: end XDP_FA_PARAMETERS_PKG;

141: end if;
142:
143: end DELETE_ROW;
144:
145: end XDP_FA_PARAMETERS_PKG;