DBA Data[Home] [Help]

APPS.BIS_RG_SCHEDULES_PVT dependencies on FND_FORM_FUNCTIONS

Line 115: from fnd_form_functions

111:
112: begin
113: select function_id
114: into l_customize_id
115: from fnd_form_functions
116: where function_name = l_form_func_name;
117: exception
118: when no_data_found then
119: l_customize_id := null;

Line 124: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_customize_id from dual;

120: end;
121:
122: if l_customize_id is null then
123: begin
124: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_customize_id from dual;
125:
126: --aleung, 5/14/01, for gsi1av envrionment, their fnd_form_functions_pkg.insert_row has more parameters
127:
128: fnd_form_functions_pkg.INSERT_ROW(

Line 126: --aleung, 5/14/01, for gsi1av envrionment, their fnd_form_functions_pkg.insert_row has more parameters

122: if l_customize_id is null then
123: begin
124: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_customize_id from dual;
125:
126: --aleung, 5/14/01, for gsi1av envrionment, their fnd_form_functions_pkg.insert_row has more parameters
127:
128: fnd_form_functions_pkg.INSERT_ROW(
129: X_ROWID => l_rowid,
130: X_FUNCTION_ID => l_customize_id,

Line 128: fnd_form_functions_pkg.INSERT_ROW(

124: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_customize_id from dual;
125:
126: --aleung, 5/14/01, for gsi1av envrionment, their fnd_form_functions_pkg.insert_row has more parameters
127:
128: fnd_form_functions_pkg.INSERT_ROW(
129: X_ROWID => l_rowid,
130: X_FUNCTION_ID => l_customize_id,
131: X_WEB_HOST_NAME => null,
132: X_WEB_AGENT_NAME => null,

Line 154: fnd_form_functions_pkg.insert_row (l_rowid,

150: X_LAST_UPDATED_BY => l_user_id,
151: X_LAST_UPDATE_LOGIN => l_user_id);
152:
153: /*
154: fnd_form_functions_pkg.insert_row (l_rowid,
155: l_customize_id, null,null,
156: l_form_func_call,
157: null,null,null,l_form_func_name,
158: l_application_id,null,null,'JSP','BIS SCHEDULE',

Line 1062: lWebHtmlCall fnd_form_functions.web_html_call%TYPE;

1058: lRespId VARCHAR2(80);
1059: lApplicationId VARCHAR2(80);
1060: lParams VARCHAR2(2000);
1061: lsecurityGroupId NUMBER;
1062: lWebHtmlCall fnd_form_functions.web_html_call%TYPE;
1063: BEGIN
1064: getSchedulePageDetails(
1065: pRegionCode => pRegionCode
1066: ,pFunctionName => pFunctionName

Line 1138: lWebHtmlCall fnd_form_functions.web_html_call%TYPE;

1134: vRespId varchar2(80);
1135: vApplicationId varchar2(80);
1136: vParams varchar2(2000);
1137: vRequestType VARCHAR2(100);
1138: lWebHtmlCall fnd_form_functions.web_html_call%TYPE;
1139:
1140: CURSOR cFndResp (pRespId in varchar2) is
1141: select application_id
1142: from fnd_responsibility

Line 1206: from fnd_form_functions

1202: -- Schedule has been setup
1203: begin
1204: select function_id,web_html_call
1205: into vPageFunctionId,lWebHtmlCall
1206: from fnd_form_functions
1207: where function_name = 'BIS_BU_SCHEDULE_PAGE';
1208: exception
1209: when others then vPageFunctionId := null;
1210: end;

Line 1221: from fnd_form_functions

1217:
1218: begin
1219: select function_id,web_html_call
1220: into vPageFunctionId,lWebHtmlCall
1221: from fnd_form_functions
1222: where function_name = 'BIS_AU_SCHEDULE_PAGE';
1223: exception
1224: when others then vPageFunctionId := null;
1225: end;

Line 1235: from fnd_form_functions

1231: -- If Schedule has not been setup for this report
1232: -- made into local call for bug 5031067
1233: select function_id, web_html_call
1234: into vPageFunctionId, lWebHtmlCall
1235: from fnd_form_functions
1236: where function_name = 'BIS_SCHEDULE_PAGE';
1237: vParams := 'regionCode='|| pRegionCode
1238: ||'&functionName='||pFunctionName
1239: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)

Line 1486: from fnd_form_functions

1482: -- default Schedule has expired
1483: -- Show Error Page
1484: begin
1485: select function_id into vPageFunctionId
1486: from fnd_form_functions
1487: where function_name = 'BIS_INFORMATION_PAGE';
1488: exception
1489: when others then vPageFunctionId := null;
1490: end;

Line 1648: from fnd_form_functions

1644:
1645: -- Show Confirmation Page
1646: begin
1647: select function_id into vPageFunctionId
1648: from fnd_form_functions
1649: where function_name = 'BIS_CONFIRMATION_PAGE';
1650: exception
1651: when others then vPageFunctionId := null;
1652: end;

Line 1753: vFunctionName fnd_form_functions.function_name%TYPE;

1749:
1750: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
1751: vGraphFileId varchar2(20);
1752: vAttrName varchar2(20);
1753: vFunctionName fnd_form_functions.function_name%TYPE;
1754:
1755: vParams varchar2(2000);
1756: vRespId varchar2(80);
1757: vApplicationId varchar2(80);

Line 1855: from fnd_form_functions

1851:
1852: -- Show Confirmation Page
1853: begin
1854: select function_id into vPageFunctionId
1855: from fnd_form_functions
1856: where function_name = 'BIS_CONFIRMATION_PAGE';
1857: exception
1858: when others then vPageFunctionId := null;
1859: end;

Line 2022: vFunctionName fnd_form_functions.function_name%TYPE;

2018:
2019: vCount number;
2020: vScheduleId number;
2021: -- jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
2022: vFunctionName fnd_form_functions.function_name%TYPE;
2023: vRequestType varchar2(1);
2024:
2025: begin
2026:

Line 2471: from fnd_form_functions

2467: CLOSE cFNDResp;
2468:
2469: begin
2470: select function_id into vPageFunctionId
2471: from fnd_form_functions
2472: where function_name = 'BIS_INFORMATION_PAGE';
2473: exception
2474: when others then vPageFunctionId := null;
2475: end;

Line 2515: vFunctionName fnd_form_functions.function_name%TYPE;

2511: vSQL varchar2(1000);
2512: vPortletPlugExists number;
2513: vTitle varchar2(2000);
2514: vRegion varchar2(240);
2515: vFunctionName fnd_form_functions.function_name%TYPE;
2516: vType varchar2(30);
2517:
2518: begin
2519:

Line 2535: from bis_scheduler s, fnd_form_functions f

2531:
2532: begin
2533: select s.function_name, type
2534: into vFunctionName, vType
2535: from bis_scheduler s, fnd_form_functions f
2536: where schedule_id = p_schedule_id
2537: and s.function_name = f.function_name;
2538: exception
2539: when others then null;