eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_ALERT dependencies on BIS_ACTUAL_PUB

Line 107: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

103: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
104: l_actual NUMBER;
105: l_target NUMBER;
106: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
107: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
108: l_workflow_item_type VARCHAR2(8);
109: l_workflow_process VARCHAR2(30);
110: l_notify_resp VARCHAR2(100);
111: l_responsibility_ID NUMBER;

Line 184: BIS_ACTUAL_PUB.Retrieve_User_Selections

180: FROM bisbv_target_levels
181: WHERE target_level_short_name = p_target_level_short_name;
182:
183: -- Get the KPIs users have selected to monitor on their homepage
184: BIS_ACTUAL_PUB.Retrieve_User_Selections
185: ( p_api_version => 1.0
186: ,p_Target_Level_Rec => l_Target_Level_Rec
187: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
188: ,x_return_status => l_return_status

Line 212: BIS_ACTUAL_PUB.POST_ACTUAL

208: l_Actual_Tbl(i).time_Level_value_ID := cr_a.month;
209: l_Actual_Tbl(i).Target_Level_ID := cr_a.month;
210: l_Actual_Tbl(i).Actual := l_actual;
211:
212: BIS_ACTUAL_PUB.POST_ACTUAL
213: ( p_api_version => 1.0
214: ,p_Actual_Rec => l_actual_Tbl(i)
215: ,x_return_status => l_return_status
216: ,x_msg_count => l_msg_count

Line 243: BIS_ACTUAL_PUB.POST_ACTUAL

239: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
240: l_Actual_Tbl(1).Actual := l_actual;
241: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
242: L_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
243: BIS_ACTUAL_PUB.POST_ACTUAL
244: ( p_api_version => 1.0
245: ,p_Actual_Rec => l_actual_Tbl(1)
246: ,x_return_status => l_return_status
247: ,x_msg_count => l_msg_count

Line 389: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: l_actual NUMBER;
387: l_target NUMBER;
388: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
389: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
390: l_workflow_item_type VARCHAR2(8);
391: l_workflow_process VARCHAR2(30);
392: l_notify_resp VARCHAR2(100);
393: l_responsibility_ID NUMBER;

Line 465: BIS_ACTUAL_PUB.Retrieve_User_Selections

461: FROM bisbv_target_levels
462: WHERE target_level_short_name = p_target_level_short_name;
463:
464: -- Get the KPIs users have selected to monitor on their homepage
465: BIS_ACTUAL_PUB.Retrieve_User_Selections
466: ( p_api_version => 1.0
467: ,p_Target_Level_Rec => l_Target_Level_Rec
468: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
469: ,x_return_status => l_return_status

Line 504: BIS_ACTUAL_PUB.POST_ACTUAL

500: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
501: l_Actual_Tbl(1).Actual := l_actual;
502: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
503: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
504: BIS_ACTUAL_PUB.POST_ACTUAL
505: ( p_api_version => 1.0
506: ,p_Actual_Rec => l_actual_Tbl(1)
507: ,x_return_status => l_return_status
508: ,x_msg_count => l_msg_count

Line 647: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
644: l_actual NUMBER;
645: l_target NUMBER;
646: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
647: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
648: l_workflow_item_type VARCHAR2(8);
649: l_workflow_process VARCHAR2(30);
650: l_notify_resp VARCHAR2(100);
651: l_responsibility_ID NUMBER;

Line 720: BIS_ACTUAL_PUB.Retrieve_User_Selections

716: FROM bisbv_target_levels
717: WHERE target_level_short_name = p_target_level_short_name;
718:
719: -- Get the KPIs users have selected to monitor on their homepage
720: BIS_ACTUAL_PUB.Retrieve_User_Selections
721: ( p_api_version => 1.0
722: ,p_Target_Level_Rec => l_Target_Level_Rec
723: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
724: ,x_return_status => l_return_status

Line 760: BIS_ACTUAL_PUB.POST_ACTUAL

756: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
757: l_Actual_Tbl(1).Actual := l_actual;
758: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
759: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
760: BIS_ACTUAL_PUB.POST_ACTUAL
761: ( p_api_version => 1.0
762: ,p_Actual_Rec => l_actual_Tbl(1)
763: ,x_return_status => l_return_status
764: ,x_msg_count => l_msg_count

Line 951: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

947: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
948: l_actual NUMBER;
949: l_target NUMBER;
950: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
951: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
952: l_workflow_item_type VARCHAR2(8);
953: l_workflow_process VARCHAR2(30);
954: l_notify_resp VARCHAR2(100);
955: l_responsibility_ID NUMBER;

Line 1027: BIS_ACTUAL_PUB.Retrieve_User_Selections

1023: INTO l_workflow_item_type, l_workflow_process
1024: FROM bisbv_target_levels
1025: WHERE target_level_short_name = p_target_level_short_name;
1026: -- Get the KPIs users have selected to monitor on their homepage
1027: BIS_ACTUAL_PUB.Retrieve_User_Selections
1028: ( p_api_version => 1.0
1029: ,p_Target_Level_Rec => l_Target_Level_Rec
1030: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
1031: ,x_return_status => l_return_status

Line 1068: BIS_ACTUAL_PUB.POST_ACTUAL

1064: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
1065: l_Actual_Tbl(1).Actual := l_actual;
1066: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
1067: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
1068: BIS_ACTUAL_PUB.POST_ACTUAL
1069: ( p_api_version => 1.0
1070: ,p_Actual_Rec => l_actual_Tbl(1)
1071: ,x_return_status => l_return_status
1072: ,x_msg_count => l_msg_count

Line 1259: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

1255: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1256: l_actual NUMBER;
1257: l_target NUMBER;
1258: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
1259: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
1260: l_workflow_item_type VARCHAR2(8);
1261: l_workflow_process VARCHAR2(30);
1262: l_notify_resp VARCHAR2(100);
1263: l_responsibility_ID NUMBER;

Line 1333: BIS_ACTUAL_PUB.Retrieve_User_Selections

1329: FROM bisbv_target_levels
1330: WHERE target_level_short_name = p_target_level_short_name;
1331:
1332: -- Get the KPIs users have selected to monitor on their homepage
1333: BIS_ACTUAL_PUB.Retrieve_User_Selections
1334: ( p_api_version => 1.0
1335: ,p_Target_Level_Rec => l_Target_Level_Rec
1336: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
1337: ,x_return_status => l_return_status

Line 1373: BIS_ACTUAL_PUB.POST_ACTUAL

1369: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
1370: l_Actual_Tbl(1).Actual := l_actual;
1371: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
1372: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
1373: BIS_ACTUAL_PUB.POST_ACTUAL
1374: ( p_api_version => 1.0
1375: ,p_Actual_Rec => l_actual_Tbl(1)
1376: ,x_return_status => l_return_status
1377: ,x_msg_count => l_msg_count

Line 1516: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

1512: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1513: l_actual NUMBER;
1514: l_target NUMBER;
1515: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
1516: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
1517: l_workflow_item_type VARCHAR2(8);
1518: l_workflow_process VARCHAR2(30);
1519: l_notify_resp VARCHAR2(100);
1520: l_responsibility_ID NUMBER;

Line 1592: BIS_ACTUAL_PUB.Retrieve_User_Selections

1588: FROM bisbv_target_levels
1589: WHERE target_level_short_name = p_target_level_short_name;
1590:
1591: -- Get the KPIs users have selected to monitor on their homepage
1592: BIS_ACTUAL_PUB.Retrieve_User_Selections
1593: ( p_api_version => 1.0
1594: ,p_Target_Level_Rec => l_Target_Level_Rec
1595: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
1596: ,x_return_status => l_return_status

Line 1633: BIS_ACTUAL_PUB.POST_ACTUAL

1629: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
1630: l_Actual_Tbl(1).Actual := l_actual;
1631: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
1632: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
1633: BIS_ACTUAL_PUB.POST_ACTUAL
1634: ( p_api_version => 1.0
1635: ,p_Actual_Rec => l_actual_Tbl(1)
1636: ,x_return_status => l_return_status
1637: ,x_msg_count => l_msg_count

Line 1779: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

1775: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1776: l_actual NUMBER;
1777: l_target NUMBER;
1778: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
1779: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
1780: l_workflow_item_type VARCHAR2(8);
1781: l_workflow_process VARCHAR2(30);
1782: l_notify_resp VARCHAR2(100);
1783: l_responsibility_ID NUMBER;

Line 1856: BIS_ACTUAL_PUB.Retrieve_User_Selections

1852: FROM bisbv_target_levels
1853: WHERE target_level_short_name = p_target_level_short_name;
1854:
1855: -- Get the KPIs users have selected to monitor on their homepage
1856: BIS_ACTUAL_PUB.Retrieve_User_Selections
1857: ( p_api_version => 1.0
1858: ,p_Target_Level_Rec => l_Target_Level_Rec
1859: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
1860: ,x_return_status => l_return_status

Line 1898: BIS_ACTUAL_PUB.POST_ACTUAL

1894: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
1895: l_Actual_Tbl(1).Actual := l_actual;
1896: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
1897: l_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
1898: BIS_ACTUAL_PUB.POST_ACTUAL
1899: ( p_api_version => 1.0
1900: ,p_Actual_Rec => l_actual_Tbl(1)
1901: ,x_return_status => l_return_status
1902: ,x_msg_count => l_msg_count

Line 2043: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;

2039: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2040: l_actual NUMBER;
2041: l_target NUMBER;
2042: l_Target_Rec BIS_TARGET_PUB.Target_Rec_Type;
2043: l_Actual_Tbl BIS_ACTUAL_PUB.Actual_Tbl_Type;
2044: l_workflow_item_type VARCHAR2(8);
2045: l_workflow_process VARCHAR2(30);
2046: l_notify_resp VARCHAR2(100);
2047: l_responsibility_ID NUMBER;

Line 2118: BIS_ACTUAL_PUB.Retrieve_User_Selections

2114: FROM bisbv_target_levels
2115: WHERE target_level_short_name = p_target_level_short_name;
2116:
2117: -- Get the KPIs users have selected to monitor on their homepage
2118: BIS_ACTUAL_PUB.Retrieve_User_Selections
2119: ( p_api_version => 1.0
2120: ,p_Target_Level_Rec => l_Target_Level_Rec
2121: ,x_Indicator_Region_Tbl => l_user_selection_Tbl
2122: ,x_return_status => l_return_status

Line 2150: BIS_ACTUAL_PUB.POST_ACTUAL

2146: l_Actual_Tbl(1).target_Level_ID := cr_t.target_level_id;
2147: l_Actual_Tbl(1).Actual := l_actual;
2148: l_Actual_Tbl(1).dim1_Level_value_ID := cr_t.dim1_level_value_id;
2149: L_Actual_Tbl(1).target_level_name := cr_t.target_level_name;
2150: BIS_ACTUAL_PUB.POST_ACTUAL
2151: ( p_api_version => 1.0
2152: ,p_Actual_Rec => l_actual_Tbl(1)
2153: ,x_return_status => l_return_status
2154: ,x_msg_count => l_msg_count