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.PQP_GB_GAP_BEN_FORMULAS dependencies on FF_FORMULAS_F

Line 127: l_formula_name ff_formulas.formula_name%TYPE;-- VARCHAR2(80)

123: ,p_error_message OUT NOCOPY VARCHAR2
124: )
125: IS
126:
127: l_formula_name ff_formulas.formula_name%TYPE;-- VARCHAR2(80)
128: l_formula_type ff_formula_types.formula_type_name%TYPE;-- VARCHAR2(80)
129: l_description ff_formulas.description%TYPE;-- VARCHAR2(240)
130: l_formula_type_id ff_formula_types.formula_type_id%TYPE;
131:

Line 350: INSERT INTO ff_formulas_f

346: debug(l_business_group_id||';'||l_legislation_code,31);
347: debug(l_formula_type_id||';'||l_formula_name,31);
348:
349: l_formula_count:= l_formula_count + 1;
350: INSERT INTO ff_formulas_f
351: (formula_id
352: ,effective_start_date
353: ,effective_end_date
354: ,business_group_id

Line 374: -- FROM ff_formulas_f

370: ,NULL
371: )
372: -- WHERE NOT EXISTS
373: -- (SELECT 1
374: -- FROM ff_formulas_f
375: -- WHERE formula_name = l_formula_name
376: -- AND business_group_id = l_business_group_id
377: -- )
378: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 380: UPDATE ff_formulas_f

376: -- AND business_group_id = l_business_group_id
377: -- )
378: RETURNING formula_id INTO p_formulas(l_formula_count);
379:
380: UPDATE ff_formulas_f
381: SET formula_text = l_text
382: WHERE formula_id = p_formulas(l_formula_count)
383: -- formula_name = l_formula_name
384: -- AND business_group_id = l_business_group_id

Line 578: INSERT INTO ff_formulas_f

574: WHERE formula_type_name = l_formula_type;
575:
576: debug(l_proc_name,39);
577: l_formula_count := l_formula_count + 1;
578: INSERT INTO ff_formulas_f
579: (formula_id
580: ,effective_start_date
581: ,effective_end_date
582: ,business_group_id

Line 602: -- FROM ff_formulas_f

598: ,NULL
599: )
600: -- WHERE NOT EXISTS
601: -- (SELECT 1
602: -- FROM ff_formulas_f
603: -- WHERE formula_name = l_formula_name
604: -- AND business_group_id = l_business_group_id
605: -- )
606: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 608: UPDATE ff_formulas_f

604: -- AND business_group_id = l_business_group_id
605: -- )
606: RETURNING formula_id INTO p_formulas(l_formula_count);
607:
608: UPDATE ff_formulas_f
609: SET formula_text = l_text
610: WHERE formula_id = p_formulas(l_formula_count);
611:
612: END IF;

Line 932: INSERT INTO ff_formulas_f

928: WHERE formula_type_name = l_formula_type;
929:
930: debug(l_proc_name,49);
931: l_formula_count := l_formula_count + 1;
932: INSERT INTO ff_formulas_f
933: (formula_id
934: ,effective_start_date
935: ,effective_end_date
936: ,business_group_id

Line 956: -- FROM ff_formulas_f

952: ,NULL
953: )
954: -- WHERE NOT EXISTS
955: -- (SELECT 1
956: -- FROM ff_formulas_f
957: -- WHERE formula_name = l_formula_name
958: -- AND business_group_id = l_business_group_id
959: -- )
960: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 962: UPDATE ff_formulas_f

958: -- AND business_group_id = l_business_group_id
959: -- )
960: RETURNING formula_id INTO p_formulas(l_formula_count);
961:
962: UPDATE ff_formulas_f
963: SET formula_text = l_text
964: WHERE formula_id = p_formulas(l_formula_count);
965:
966: END IF;

Line 1109: INSERT INTO ff_formulas_f

1105: WHERE formula_type_name = l_formula_type;
1106:
1107: debug(l_proc_name,59);
1108: l_formula_count := l_formula_count + 1;
1109: INSERT INTO ff_formulas_f
1110: (formula_id
1111: ,effective_start_date
1112: ,effective_end_date
1113: ,business_group_id

Line 1133: -- FROM ff_formulas_f

1129: ,NULL
1130: )
1131: -- WHERE NOT EXISTS
1132: -- (SELECT 1
1133: -- FROM ff_formulas_f
1134: -- WHERE formula_name = l_formula_name
1135: -- AND business_group_id = l_business_group_id
1136: -- )
1137: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 1139: UPDATE ff_formulas_f

1135: -- AND business_group_id = l_business_group_id
1136: -- )
1137: RETURNING formula_id INTO p_formulas(l_formula_count);
1138:
1139: UPDATE ff_formulas_f
1140: SET formula_text = l_text
1141: WHERE formula_id = p_formulas(l_formula_count);
1142:
1143: END;

Line 1270: INSERT INTO ff_formulas_f

1266: WHERE formula_type_name = l_formula_type;
1267:
1268: debug(l_proc_name,69);
1269: l_formula_count := l_formula_count + 1;
1270: INSERT INTO ff_formulas_f
1271: (formula_id
1272: ,effective_start_date
1273: ,effective_end_date
1274: ,business_group_id

Line 1294: -- FROM ff_formulas_f

1290: ,NULL
1291: )
1292: -- WHERE NOT EXISTS
1293: -- (SELECT 1
1294: -- FROM ff_formulas_f
1295: -- WHERE formula_name = l_formula_name
1296: -- AND business_group_id = l_business_group_id
1297: -- )
1298: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 1300: UPDATE ff_formulas_f

1296: -- AND business_group_id = l_business_group_id
1297: -- )
1298: RETURNING formula_id INTO p_formulas(l_formula_count);
1299:
1300: UPDATE ff_formulas_f
1301: SET formula_text = l_text
1302: WHERE formula_id = p_formulas(l_formula_count);
1303:
1304: --hr_utility.trace('Updated '||SQL%ROWCOUNT||' formulae.');

Line 1606: INSERT INTO ff_formulas_f

1602: WHERE formula_type_name = l_formula_type;
1603:
1604: debug(l_proc_name,79);
1605: l_formula_count := l_formula_count + 1;
1606: INSERT INTO ff_formulas_f
1607: (formula_id
1608: ,effective_start_date
1609: ,effective_end_date
1610: ,business_group_id

Line 1630: -- FROM ff_formulas_f

1626: ,NULL
1627: )
1628: -- WHERE NOT EXISTS
1629: -- (SELECT 1
1630: -- FROM ff_formulas_f
1631: -- WHERE formula_name = l_formula_name
1632: -- AND business_group_id = l_business_group_id
1633: -- )
1634: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 1636: UPDATE ff_formulas_f

1632: -- AND business_group_id = l_business_group_id
1633: -- )
1634: RETURNING formula_id INTO p_formulas(l_formula_count);
1635:
1636: UPDATE ff_formulas_f
1637: SET formula_text = l_text
1638: WHERE formula_id = p_formulas(l_formula_count);
1639:
1640: END;

Line 1781: INSERT INTO ff_formulas_f

1777: WHERE formula_type_name = l_formula_type;
1778:
1779: debug(l_proc_name,89);
1780: l_formula_count := l_formula_count + 1;
1781: INSERT INTO ff_formulas_f
1782: (formula_id
1783: ,effective_start_date
1784: ,effective_end_date
1785: ,business_group_id

Line 1805: -- FROM ff_formulas_f

1801: ,NULL
1802: )
1803: -- WHERE NOT EXISTS
1804: -- (SELECT 1
1805: -- FROM ff_formulas_f
1806: -- WHERE formula_name = l_formula_name
1807: -- AND business_group_id = l_business_group_id
1808: -- )
1809: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 1811: UPDATE ff_formulas_f

1807: -- AND business_group_id = l_business_group_id
1808: -- )
1809: RETURNING formula_id INTO p_formulas(l_formula_count);
1810:
1811: UPDATE ff_formulas_f
1812: SET formula_text = l_text
1813: WHERE formula_id = p_formulas(l_formula_count);
1814:
1815: END;

Line 2120: INSERT INTO ff_formulas_f

2116: WHERE formula_type_name = l_formula_type;
2117:
2118: debug(l_proc_name,99);
2119: l_formula_count := l_formula_count + 1;
2120: INSERT INTO ff_formulas_f
2121: (formula_id
2122: ,effective_start_date
2123: ,effective_end_date
2124: ,business_group_id

Line 2144: -- FROM ff_formulas_f

2140: ,NULL
2141: )
2142: -- WHERE NOT EXISTS
2143: -- (SELECT 1
2144: -- FROM ff_formulas_f
2145: -- WHERE formula_name = l_formula_name
2146: -- AND business_group_id = l_business_group_id
2147: -- )
2148: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 2150: UPDATE ff_formulas_f

2146: -- AND business_group_id = l_business_group_id
2147: -- )
2148: RETURNING formula_id INTO p_formulas(l_formula_count);
2149:
2150: UPDATE ff_formulas_f
2151: SET formula_text = l_text
2152: WHERE formula_id = p_formulas(l_formula_count);
2153:
2154: END;

Line 2475: --DELETE FROM ff_formulas_f WHERE formula_name = l_formula_name;

2471: INTO l_formula_type_id
2472: FROM ff_formula_types
2473: WHERE formula_type_name = l_formula_type;
2474:
2475: --DELETE FROM ff_formulas_f WHERE formula_name = l_formula_name;
2476:
2477: debug(l_proc_name,109);
2478: l_formula_count := l_formula_count + 1;
2479: INSERT INTO ff_formulas_f

Line 2479: INSERT INTO ff_formulas_f

2475: --DELETE FROM ff_formulas_f WHERE formula_name = l_formula_name;
2476:
2477: debug(l_proc_name,109);
2478: l_formula_count := l_formula_count + 1;
2479: INSERT INTO ff_formulas_f
2480: (formula_id
2481: ,effective_start_date
2482: ,effective_end_date
2483: ,business_group_id

Line 2503: -- FROM ff_formulas_f

2499: ,NULL
2500: )
2501: -- WHERE NOT EXISTS
2502: -- (SELECT 1
2503: -- FROM ff_formulas_f
2504: -- WHERE formula_name = l_formula_name
2505: -- AND business_group_id = l_business_group_id
2506: -- )
2507: RETURNING formula_id INTO p_formulas(l_formula_count);

Line 2509: UPDATE ff_formulas_f

2505: -- AND business_group_id = l_business_group_id
2506: -- )
2507: RETURNING formula_id INTO p_formulas(l_formula_count);
2508:
2509: UPDATE ff_formulas_f
2510: SET formula_text = l_text
2511: WHERE formula_id = p_formulas(l_formula_count);
2512:
2513: END;

Line 2551: l_formula_name ff_formulas_f.formula_name%TYPE;

2547: l_proc_name VARCHAR2(61):= g_proc_name||'delete_ben_formulas';
2548:
2549:
2550: l_formula_name_prefix VARCHAR2(100);
2551: l_formula_name ff_formulas_f.formula_name%TYPE;
2552:
2553: BEGIN
2554: debug_enter(l_proc_name); -- comment to switch tracing on
2555: