APPS.OKC_BUSINESS_VARIABLES_PVT dependencies on OKC_BUS_VARIABLES_B

Line 14: l_variable_datatype OKC_BUS_VARIABLES_B.Variable_datatype%TYPE;

10: Function Resolve_Var_Data_Type(p_value_set_id IN NUMBER,
11: p_variable_type IN VARCHAR2,
12: p_variable_datatype IN VARCHAR2)
13: Return VARCHAR2 IS
14: l_variable_datatype OKC_BUS_VARIABLES_B.Variable_datatype%TYPE;
15: Cursor l_Data_Type_Csr(lc_value_set_id NUMBER) IS
16: Select Decode(format_type,'C','V','X','D',format_type) format_type
17: From fnd_flex_value_sets
18: Where flex_value_set_id = lc_value_set_id

Line 89: cursor C is select ROWID from OKC_BUS_VARIABLES_B

85: X_CLM_REF5 IN VARCHAR2, -- CLM Changes
86: X_MRV_FLAG IN VARCHAR2, -- MRV Changes
87: X_MRV_TMPL_CODE IN VARCHAR2 -- MRV Changes
88: ) is
89: cursor C is select ROWID from OKC_BUS_VARIABLES_B
90: where VARIABLE_CODE = X_VARIABLE_CODE
91: ;
92: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
93:

Line 92: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;

88: ) is
89: cursor C is select ROWID from OKC_BUS_VARIABLES_B
90: where VARIABLE_CODE = X_VARIABLE_CODE
91: ;
92: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
93:
94:
95: begin
96: L_VARIABLE_DATATYPE :=

Line 98: insert into OKC_BUS_VARIABLES_B (

94:
95: begin
96: L_VARIABLE_DATATYPE :=
97: Resolve_Var_Data_Type(X_VALUE_SET_ID,X_VARIABLE_TYPE,X_VARIABLE_DATATYPE);
98: insert into OKC_BUS_VARIABLES_B (
99: VARIABLE_DEFAULT_VALUE,
100: VARIABLE_DATATYPE,
101: VARIABLE_CODE,
102: OBJECT_VERSION_NUMBER,

Line 329: from OKC_BUS_VARIABLES_B

325: CLM_REF4, -- CLM Changes
326: CLM_REF5, -- CLM Changes
327: MRV_FLAG, -- MRV Changes
328: MRV_TMPL_CODE -- MRV Changes
329: from OKC_BUS_VARIABLES_B
330: where VARIABLE_CODE = X_VARIABLE_CODE
331: for update of VARIABLE_CODE nowait;
332: recinfo c%rowtype;
333:

Line 507: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;

503: X_CLM_REF5 IN VARCHAR2, -- CLM Changes
504: X_MRV_FLAG IN VARCHAR2, -- MRV Changes
505: X_MRV_TMPL_CODE IN VARCHAR2 -- MRV Changes
506: ) is
507: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
508: begin
509: L_VARIABLE_DATATYPE :=
510: Resolve_Var_Data_Type(X_VALUE_SET_ID,X_VARIABLE_TYPE,X_VARIABLE_DATATYPE);
511: update OKC_BUS_VARIABLES_B set

Line 511: update OKC_BUS_VARIABLES_B set

507: L_VARIABLE_DATATYPE OKC_BUS_VARIABLES_B.VARIABLE_DATATYPE%TYPE;
508: begin
509: L_VARIABLE_DATATYPE :=
510: Resolve_Var_Data_Type(X_VALUE_SET_ID,X_VARIABLE_TYPE,X_VARIABLE_DATATYPE);
511: update OKC_BUS_VARIABLES_B set
512: VARIABLE_DEFAULT_VALUE = X_VARIABLE_DEFAULT_VALUE,
513: VARIABLE_DATATYPE = L_VARIABLE_DATATYPE,
514: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
515: VARIABLE_TYPE = X_VARIABLE_TYPE,

Line 595: delete from OKC_BUS_VARIABLES_B

591: raise no_data_found;
592:
593: end if;
594:
595: delete from OKC_BUS_VARIABLES_B
596: where VARIABLE_CODE = X_VARIABLE_CODE;
597:
598: if (sql%notfound) then
599: raise no_data_found;

Line 639: from OKC_BUS_VARIABLES_B B

635: begin
636: delete from OKC_BUS_VARIABLES_TL T
637: where not exists
638: (select NULL
639: from OKC_BUS_VARIABLES_B B
640: where B.VARIABLE_CODE = T.VARIABLE_CODE
641: );
642:
643: update OKC_BUS_VARIABLES_TL T set (