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.OE_UPGRADE_WF2 dependencies on OE_ACTION_PRE_REQS

Line 849: To populate the local table oe_action_pre_reqs from so_action_pre_reqs

845: End Create_Process_Activity;
846:
847:
848: /*
849: To populate the local table oe_action_pre_reqs from so_action_pre_reqs
850: This takes care of the putting an AND activitiy in the appropriate place.
851: */
852:
853: PROCEDURE Create_Activity_And

Line 971: INSERT INTO oe_action_pre_reqs

967: IF v_mul_rec_grp_flag = 'N' THEN
968:
969: v_error_level := 2052;
970: -- dbms_output.put_line('In the stage 4..');
971: INSERT INTO oe_action_pre_reqs
972: (
973: cycle_action_id,
974: action_id,
975: result_id,

Line 1003: INSERT INTO oe_action_pre_reqs

999: IF c2.group_number = v_group_number THEN
1000:
1001: v_error_level := 2054;
1002: -- dbms_output.put_line('In the stage 6..');
1003: INSERT INTO oe_action_pre_reqs
1004: (
1005: cycle_action_id,
1006: action_id,
1007: result_id,

Line 1066: INSERT INTO oe_action_pre_reqs

1062: -- dbms_output.put_line('In the stage 7.2 error:'
1063: -- ||to_char(v_api_error_level));
1064:
1065: v_error_level := 2056;
1066: INSERT INTO oe_action_pre_reqs
1067: (
1068: cycle_action_id,
1069: action_id,
1070: result_id,

Line 1092: INSERT INTO oe_action_pre_reqs

1088: v_last_instance_id
1089: );
1090:
1091: v_error_level := 2057;
1092: INSERT INTO oe_action_pre_reqs
1093: (
1094: cycle_action_id,
1095: action_id,
1096: result_id,

Line 1208: FROM oe_action_pre_reqs pr

1204: SELECT
1205: pr.instance_id,
1206: pr.instance_label,
1207: pr.rowid
1208: FROM oe_action_pre_reqs pr
1209: WHERE pr.cycle_id = v_cycle_id
1210: AND pr.action_id = v_action_id
1211: and pr.line_type = p_line_type -- included 3/24/00
1212: FOR UPDATE;

Line 1218: FROM oe_action_pre_reqs pr

1214: CURSOR c5 IS
1215: SELECT
1216: pr.instance_id,
1217: pr.rowid
1218: FROM oe_action_pre_reqs pr
1219: WHERE pr.cycle_id = v_cycle_id
1220: AND pr.cycle_action_id = v_cycle_action_id
1221: AND pr.line_type = p_line_type -- included 3/24/00
1222: FOR UPDATE;

Line 1456: UPDATE oe_action_pre_reqs

1452: -- dbms_output.put_line('Stage D18');
1453:
1454: IF c4.instance_id IS null THEN
1455: -- dbms_output.put_line('Stage D19');
1456: UPDATE oe_action_pre_reqs
1457: SET
1458: action_id = null,
1459: result_id = null,
1460: instance_label = 'Interdependecy-Hdr',

Line 1465: UPDATE oe_action_pre_reqs

1461: instance_id = v_instance_id
1462: WHERE rowid = c4.rowid;
1463: ELSE
1464: -- dbms_output.put_line('Stage D20');
1465: UPDATE oe_action_pre_reqs
1466: SET
1467: instance_id2 = c4.instance_id,
1468: instance_label2 = c4.instance_label,
1469: instance_id= v_instance_id,

Line 1481: INSERT INTO oe_action_pre_reqs

1477:
1478: -- dbms_output.put_line('Stage D21');
1479:
1480: v_error_level := 2070;
1481: INSERT INTO oe_action_pre_reqs
1482: (
1483: cycle_action_id,
1484: action_id,
1485: result_id,

Line 1681: INSERT INTO oe_action_pre_reqs

1677:
1678: v_action_id := c2.lin_action_id;
1679: v_result_table := 'SO_LINES';
1680:
1681: INSERT INTO oe_action_pre_reqs
1682: (
1683: group_number,
1684: cycle_id,
1685: type,

Line 1703: INSERT INTO oe_action_pre_reqs

1699: v_instance_id
1700: );
1701:
1702:
1703: INSERT INTO oe_action_pre_reqs
1704: (
1705: cycle_action_id,
1706: action_id,
1707: result_id,

Line 1778: UPDATE oe_action_pre_reqs

1774: -- dbms_output.put_line('Stage N24');
1775:
1776: IF c6.instance_id IS null THEN
1777: -- dbms_output.put_line('Stage N25');
1778: UPDATE oe_action_pre_reqs
1779: SET
1780: cycle_action_id = null,
1781: instance_label = 'ENTER',
1782: instance_id = v_instance_id

Line 1786: UPDATE oe_action_pre_reqs

1782: instance_id = v_instance_id
1783: WHERE rowid = c6.rowid;
1784: ELSE
1785: -- dbms_output.put_line('Stage N26');
1786: UPDATE oe_action_pre_reqs
1787: SET
1788: cycle_action_id = null,
1789: instance_id2 = v_instance_id,
1790: instance_label2 = 'ENTER'

Line 1802: INSERT INTO oe_action_pre_reqs

1798: -- dbms_output.put_line('Stage N21');
1799:
1800: v_error_level := 3070;
1801:
1802: INSERT INTO oe_action_pre_reqs
1803: (
1804: cycle_action_id,
1805: action_id,
1806: result_id,

Line 1828: INSERT INTO oe_action_pre_reqs

1824: v_instance_id
1825: );
1826: */
1827: --sam
1828: INSERT INTO oe_action_pre_reqs
1829: (
1830: cycle_action_id,
1831: action_id,
1832: result_id,

Line 1882: FROM oe_action_pre_reqs

1878:
1879: IS
1880: CURSOR c1 IS
1881: SELECT cycle_action_id, action_id, result_id, group_number, rowid
1882: FROM oe_action_pre_reqs
1883: WHERE cycle_action_id IS NOT null
1884: AND type = p_item_type
1885: AND line_type = p_line_type
1886: AND cycle_action_id in

Line 1888: FROM oe_action_pre_reqs

1884: AND type = p_item_type
1885: AND line_type = p_line_type
1886: AND cycle_action_id in
1887: (SELECT cycle_action_id
1888: FROM oe_action_pre_reqs
1889: WHERE cycle_action_id is not null
1890: AND cycle_id = p_cycle_id
1891: GROUP BY cycle_action_id
1892: HAVING count(*) > 1)

Line 1915: FROM oe_action_pre_reqs

1911: -- dbms_output.put_line('Stage 1');
1912: BEGIN
1913: SELECT count(distinct group_number)
1914: INTO v_count
1915: FROM oe_action_pre_reqs
1916: WHERE cycle_action_id = c2.cycle_action_id;
1917: EXCEPTION
1918: WHEN OTHERS THEN
1919: null;

Line 1974: INSERT INTO oe_action_pre_reqs

1970:
1971: -- dbms_output.put_line('Stage 3 error: '||to_char(v_api_error_level));
1972:
1973: v_error_level := 2083;
1974: INSERT INTO oe_action_pre_reqs
1975: (
1976: cycle_action_id,
1977: action_id,
1978: result_id,

Line 2005: UPDATE oe_action_pre_reqs

2001: );
2002:
2003: END IF;
2004:
2005: UPDATE oe_action_pre_reqs
2006: SET cycle_action_id = null,
2007: instance_label2 = v_instance_label,
2008: instance_id2 = v_last_instance_id
2009: WHERE rowid = c2.rowid;

Line 2029: -- Based on table oe_action_pre_reqs, link all the activities

2025: END Create_Activity_Or;
2026:
2027:
2028: /*=============================================================
2029: -- Based on table oe_action_pre_reqs, link all the activities
2030: -- into wf_activity_transition table
2031: ==============================================================*/
2032:
2033: PROCEDURE Create_Activity_Transition

Line 2049: FROM oe_action_pre_reqs

2045: decode(result_id,null,'*','UPG_RC_'||to_char(result_id)) result_code,
2046: cycle_id,
2047: instance_id,
2048: instance_id2
2049: FROM oe_action_pre_reqs
2050: WHERE type = p_item_type
2051: AND cycle_id = p_cycle_id
2052: AND line_type = p_line_type;
2053:

Line 3720: update oe_action_pre_reqs

3716: END IF;
3717: END IF;
3718:
3719: -- -2 is for ENTERED/PARTIAL for the line action
3720: update oe_action_pre_reqs
3721: set action_id = -2
3722: where action_id = 1
3723: and type = 'OEOL'
3724: and result_id in (5, 15);

Line 3744: update oe_action_pre_reqs

3740:
3741: -- dbms_output.put_line('************* FLAG18 = '||v_error_flag);
3742: IF V_ERROR_FLAG = 'N' THEN
3743: -- -1 is for ENTERED/PARTIAL for the header action
3744: update oe_action_pre_reqs
3745: set action_id = -1
3746: where action_id = 1
3747: and type = 'OEOH'
3748: and result_id in (5, 15);