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.BIM_SET_OF_BOOKS dependencies on BIM_SET_OF_BOOKS

Line 1: PACKAGE BODY BIM_SET_OF_BOOKS AS

1: PACKAGE BODY BIM_SET_OF_BOOKS AS
2: /* $Header: bimsobfb.pls 120.2 2005/09/26 23:45:05 arvikuma noship $*/
3:
4: -------------------------------------------------------------------------------
5: -- PROCEDURE

Line 23: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_data';

19: ,x_month OUT NOCOPY VARCHAR2
20: ,x_quarter_num OUT NOCOPY NUMBER
21: ,x_month_num OUT NOCOPY NUMBER
22: ) IS
23: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_data';
24:
25: /* CURSOR period_info
26: IS
27: SELECT b.period_year year,

Line 134: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month';

130: (
131: p_input_date IN DATE DEFAULT sysdate
132: ,p_org_id IN NUMBER
133: ) RETURN VARCHAR2 IS
134: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month';
135: l_month VARCHAR2(30);
136:
137: CURSOR period_info
138: IS

Line 199: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr';

195: (
196: p_input_date IN DATE DEFAULT sysdate
197: ,p_org_id IN NUMBER
198: ) RETURN VARCHAR2 IS
199: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr';
200: l_qtr VARCHAR2(30);
201:
202: CURSOR period_info
203: IS

Line 261: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year';

257: (
258: p_input_date IN DATE DEFAULT sysdate
259: ,p_org_id IN NUMBER
260: ) RETURN VARCHAR2 IS
261: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year';
262: l_year VARCHAR2(30);
263:
264: CURSOR period_info
265: IS

Line 326: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_num';

322: (
323: p_input_date IN DATE DEFAULT sysdate
324: ,p_org_id IN NUMBER
325: ) RETURN NUMBER IS
326: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_num';
327: l_period_num NUMBER;
328:
329: CURSOR period_info
330: IS

Line 391: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_period';

387: ( p_name IN VARCHAR2
388: ,p_type IN VARCHAR2
389: ,p_org_id IN NUMBER
390: ) RETURN VARCHAR2 IS
391: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_period';
392: l_name VARCHAR2(30);
393:
394: CURSOR period_name IS
395: SELECT period_name

Line 457: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_month_order';

453: (
454: p_month IN VARCHAR2
455: ,p_org_id IN NUMBER
456: ) RETURN NUMBER IS
457: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_month_order';
458: l_period_num NUMBER;
459:
460: CURSOR period_info
461: IS

Line 521: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_num';

517: (
518: p_input_date IN DATE DEFAULT sysdate
519: ,p_org_id IN NUMBER
520: ) RETURN NUMBER IS
521: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_num';
522: l_period_num NUMBER;
523:
524: CURSOR period_info
525: IS

Line 586: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_roll_year_start';

582: (
583: p_input_date IN DATE DEFAULT sysdate
584: ,p_org_id IN NUMBER
585: ) RETURN DATE IS
586: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_roll_year_start';
587: l_date DATE;
588:
589: /*
590: CURSOR period_info(v_date DATE)

Line 697: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_roll_year_start';

693: (
694: p_input_date IN DATE DEFAULT sysdate
695: ,p_org_id IN NUMBER
696: ) RETURN DATE IS
697: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_roll_year_start';
698: l_date DATE;
699:
700:
701:

Line 747: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_roll_year_end';

743: (
744: p_input_date IN DATE DEFAULT sysdate
745: ,p_org_id IN NUMBER
746: ) RETURN DATE IS
747: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_roll_year_end';
748: l_date DATE;
749: l_delta NUMBER;
750:
751: BEGIN

Line 796: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year_start';

792: (
793: p_input_date IN DATE DEFAULT sysdate
794: ,p_org_id IN NUMBER
795: ) RETURN DATE IS
796: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year_start';
797: l_date DATE;
798:
799: /*
800: CURSOR period_info

Line 873: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_start';

869: (
870: p_input_date IN DATE DEFAULT sysdate
871: ,p_org_id IN NUMBER
872: ) RETURN DATE IS
873: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_start';
874: l_date DATE;
875:
876: /*
877: CURSOR period_info

Line 952: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_start';

948: (
949: p_input_date IN DATE DEFAULT sysdate
950: ,p_org_id IN NUMBER
951: ) RETURN DATE IS
952: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_start';
953: l_date DATE;
954:
955: /*
956: CURSOR period_info

Line 1135: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:GET_PRE_FISCAL_YEAR_START';

1131:
1132: l_org_id NUMBER;
1133: l_current_fiscal_year_start DATE;
1134: l_previous_fiscal_year_start DATE;
1135: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:GET_PRE_FISCAL_YEAR_START';
1136:
1137:
1138:
1139: BEGIN

Line 1186: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:GET_PRE_FISCAL_YEAR_END';

1182: l_current_fiscal_year_start DATE;
1183: l_current_fiscal_year_end DATE;
1184: l_previous_fiscal_year_start DATE;
1185: l_previous_fiscal_year_end DATE;
1186: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:GET_PRE_FISCAL_YEAR_END';
1187: l_diff NUMBER;
1188:
1189:
1190: BEGIN

Line 1230: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_month_start';

1226: (
1227: p_input_date IN DATE DEFAULT sysdate
1228: ,p_org_id IN NUMBER
1229: ) RETURN DATE IS
1230: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_month_start';
1231: l_date DATE;
1232:
1233: BEGIN
1234:

Line 1278: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_month_end';

1274: (
1275: p_input_date IN DATE DEFAULT sysdate
1276: ,p_org_id IN NUMBER
1277: ) RETURN DATE IS
1278: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_pre_fiscal_month_end';
1279: l_date DATE;
1280: l_date1 DATE;
1281: l_date2 DATE;
1282: l_delta NUMBER;

Line 1335: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_end';

1331: (
1332: p_input_date IN DATE DEFAULT sysdate
1333: ,p_org_id IN NUMBER
1334: ) RETURN DATE IS
1335: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_month_end';
1336: l_date DATE;
1337:
1338: /*
1339: CURSOR period_info

Line 1412: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_end';

1408: (
1409: p_input_date IN DATE DEFAULT sysdate
1410: ,p_org_id IN NUMBER
1411: ) RETURN DATE IS
1412: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_qtr_end';
1413: l_date DATE;
1414:
1415: /*
1416: CURSOR period_info

Line 1489: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year_end';

1485: (
1486: p_input_date IN DATE DEFAULT sysdate
1487: ,p_org_id IN NUMBER
1488: ) RETURN DATE IS
1489: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_fiscal_year_end';
1490: l_date DATE;
1491:
1492: /*
1493: CURSOR period_info

Line 1566: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_qtr_from_month';

1562: (
1563: p_period_name IN VARCHAR2
1564: ,p_org_id IN NUMBER
1565: ) RETURN VARCHAR2 IS
1566: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_qtr_from_month';
1567: l_period_name VARCHAR2(15);
1568: l_period_date DATE;
1569:
1570: CURSOR cur_period_date

Line 1649: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_year_from_qtr';

1645: (
1646: p_period_name IN VARCHAR2
1647: ,p_org_id IN NUMBER
1648: ) RETURN VARCHAR2 IS
1649: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_year_from_qtr';
1650: l_period_name VARCHAR2(15);
1651: l_period_date DATE;
1652:
1653: CURSOR cur_period_date

Line 1732: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_year_from_qtr';

1728: (
1729: p_period_name IN VARCHAR2
1730: ,p_org_id IN NUMBER
1731: ) RETURN VARCHAR2 IS
1732: l_api_name CONSTANT VARCHAR2(300) := 'bim_set_of_books:get_year_from_qtr';
1733: l_period_name VARCHAR2(15);
1734: l_period_date DATE;
1735:
1736: CURSOR cur_period_date

Line 1801: END BIM_SET_OF_BOOKS;

1797: fnd_msg_pub.add;
1798: RAISE;
1799:
1800: END GET_YEAR_FROM_QTR;
1801: END BIM_SET_OF_BOOKS;