DBA Data[Home] [Help]

APPS.BIS_UPDATE_ACTUAL_SOURCE_PVT dependencies on FND_FORM_FUNCTIONS

Line 44: FROM fnd_form_functions

40: END Update_Actual_Source;
41:
42: PROCEDURE updt_func_types_bistar AS
43: CURSOR c_updt IS SELECT type , parameters , function_id
44: FROM fnd_form_functions
45: WHERE type = 'BISTAR' FOR UPDATE OF type , parameters;
46:
47: x_return_status VARCHAR2(10);
48: BEGIN

Line 51: UPDATE fnd_form_functions SET type = NULL ,

47: x_return_status VARCHAR2(10);
48: BEGIN
49: FOR i IN c_updt LOOP
50: IF (i.parameters IS NULL OR i.parameters NOT LIKE '%pFunctionType=BISTAR%') THEN
51: UPDATE fnd_form_functions SET type = NULL ,
52: parameters = parameters||fnd_global.local_chr(38)||'pFunctionType=BISTAR'
53: WHERE current of c_updt;
54: ELSE
55: UPDATE fnd_form_functions SET type = NULL

Line 55: UPDATE fnd_form_functions SET type = NULL

51: UPDATE fnd_form_functions SET type = NULL ,
52: parameters = parameters||fnd_global.local_chr(38)||'pFunctionType=BISTAR'
53: WHERE current of c_updt;
54: ELSE
55: UPDATE fnd_form_functions SET type = NULL
56: WHERE current of c_updt;
57: END IF;
58: END LOOP;
59: EXCEPTION