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.ZPB_AC_OPS dependencies on ZPB_CYCLE_RELATIONSHIPS

Line 1095: pet_rec zpb_cycle_relationships%ROWTYPE;

1091: SELECT *
1092: FROM zpb_analysis_cycle_tasks
1093: WHERE analysis_cycle_id = ac_id_in;
1094:
1095: pet_rec zpb_cycle_relationships%ROWTYPE;
1096: delete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(2000);

Line 1104: FROM zpb_cycle_relationships

1100: BEGIN
1101: BEGIN
1102: SELECT *
1103: INTO pet_rec
1104: FROM zpb_cycle_relationships
1105: WHERE published_ac_id = ac_id_in OR
1106: editable_ac_id = ac_id_in OR
1107: tmp_ac_id = ac_id_in;
1108:

Line 1110: UPDATE zpb_cycle_relationships

1106: editable_ac_id = ac_id_in OR
1107: tmp_ac_id = ac_id_in;
1108:
1109: IF pet_rec.published_ac_id = ac_id_in THEN
1110: UPDATE zpb_cycle_relationships
1111: SET published_ac_id = NULL,
1112: LAST_UPDATED_BY = fnd_global.USER_ID,
1113: LAST_UPDATE_DATE = SYSDATE,
1114: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1117: UPDATE zpb_cycle_relationships

1113: LAST_UPDATE_DATE = SYSDATE,
1114: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1115: WHERE relationship_id = pet_rec.relationship_id;
1116: ELSIF pet_rec.editable_ac_id = ac_id_in THEN
1117: UPDATE zpb_cycle_relationships
1118: SET editable_ac_id = NULL,
1119: LAST_UPDATED_BY = fnd_global.USER_ID,
1120: LAST_UPDATE_DATE = SYSDATE,
1121: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1124: UPDATE zpb_cycle_relationships

1120: LAST_UPDATE_DATE = SYSDATE,
1121: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1122: WHERE relationship_id = pet_rec.relationship_id;
1123: ELSIF pet_rec.tmp_ac_id = ac_id_in THEN
1124: UPDATE zpb_cycle_relationships
1125: SET tmp_ac_id = NULL,
1126: LAST_UPDATED_BY = fnd_global.USER_ID,
1127: LAST_UPDATE_DATE = SYSDATE,
1128: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1132: DELETE FROM zpb_cycle_relationships

1128: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1129: WHERE relationship_id = pet_rec.relationship_id;
1130: END IF;
1131:
1132: DELETE FROM zpb_cycle_relationships
1133: WHERE published_ac_id IS NULL AND
1134: editable_ac_id IS NULL AND
1135: tmp_ac_id IS NULL;
1136: EXCEPTION

Line 1285: FROM zpb_cycle_relationships

1281: BEGIN
1282:
1283: SELECT editable_ac_id
1284: INTO return_ac_id
1285: FROM zpb_cycle_relationships
1286: WHERE published_ac_id = published_ac_id_in;
1287:
1288: editable_ac_id_out := return_ac_id;
1289:

Line 1318: FROM zpb_cycle_relationships

1314: BEGIN
1315:
1316: SELECT published_ac_id
1317: INTO return_ac_id
1318: FROM zpb_cycle_relationships
1319: WHERE editable_ac_id = editable_ac_id_in;
1320:
1321: published_ac_id_out := return_ac_id;
1322:

Line 1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;

1336:
1337: IS
1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1341: pet_rec zpb_cycle_relationships%ROWTYPE;
1342: ac_rec zpb_analysis_cycles%ROWTYPE;
1343:
1344: comments boolean := true;

Line 1341: pet_rec zpb_cycle_relationships%ROWTYPE;

1337: IS
1338: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1339: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1340: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1341: pet_rec zpb_cycle_relationships%ROWTYPE;
1342: ac_rec zpb_analysis_cycles%ROWTYPE;
1343:
1344: comments boolean := true;
1345: analy_excep boolean := true;

Line 1381: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,

1377: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1378: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1379: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1380:
1381: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1382: PUBLISHED_AC_ID,
1383: EDITABLE_AC_ID,
1384: TMP_AC_ID,
1385: LAST_UPDATE_LOGIN,

Line 1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;

1407: last_updated_by_in IN zpb_analysis_cycles.last_updated_by%TYPE,
1408: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1409: IS
1410: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1412: BEGIN
1413: SELECT *
1414: INTO pet_row_rec
1415: FROM zpb_cycle_relationships

Line 1415: FROM zpb_cycle_relationships

1411: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1412: BEGIN
1413: SELECT *
1414: INTO pet_row_rec
1415: FROM zpb_cycle_relationships
1416: WHERE published_ac_id = published_ac_id_in;
1417:
1418: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1419:

Line 1432: UPDATE zpb_cycle_relationships

1428: LAST_UPDATE_DATE = SYSDATE,
1429: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1430: WHERE analysis_cycle_id = new_ac_id;
1431:
1432: UPDATE zpb_cycle_relationships
1433: SET editable_ac_id = new_ac_id,
1434: LAST_UPDATED_BY = fnd_global.USER_ID,
1435: LAST_UPDATE_DATE = SYSDATE,
1436: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;

1448: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

Line 1453: pet_rec zpb_cycle_relationships%ROWTYPE;

1449: IS
1450: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1451: current_inst_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;

Line 1516: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,

1512: pet_rec.CREATION_DATE := SYSDATE;
1513: pet_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1514: pet_rec.LAST_UPDATE_DATE := SYSDATE;
1515: pet_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1516: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
1517: PUBLISHED_AC_ID,
1518: EDITABLE_AC_ID,
1519: TMP_AC_ID,
1520: LAST_UPDATE_LOGIN,

Line 1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;

1672: editable_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
1673: tmp_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1674: IS
1675: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1677: BEGIN
1678: SELECT *
1679: INTO pet_row_rec
1680: FROM zpb_cycle_relationships

Line 1680: FROM zpb_cycle_relationships

1676: pet_row_rec zpb_cycle_relationships%ROWTYPE;
1677: BEGIN
1678: SELECT *
1679: INTO pet_row_rec
1680: FROM zpb_cycle_relationships
1681: WHERE editable_ac_id = editable_ac_id_in;
1682:
1683: IF pet_row_rec.tmp_ac_id IS NULL THEN
1684: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

Line 1692: UPDATE zpb_cycle_relationships

1688: END IF;
1689:
1690: create_ac_copy(editable_ac_id_in, new_ac_id);
1691:
1692: UPDATE zpb_cycle_relationships
1693: SET tmp_ac_id = new_ac_id,
1694: LAST_UPDATED_BY = fnd_global.USER_ID,
1695: LAST_UPDATE_DATE = SYSDATE,
1696: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1711: FROM zpb_cycle_relationships

1707: editable_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1708: BEGIN
1709: SELECT editable_ac_id
1710: INTO editable_ac_id
1711: FROM zpb_cycle_relationships
1712: WHERE tmp_ac_id = tmp_ac_id_in;
1713:
1714: UPDATE zpb_analysis_cycles
1715: SET

Line 1835: FROM zpb_cycle_relationships

1831: IF cycle_type = 'PUBLISHED' THEN
1832: zpb_wf_ntf.notify_on_delete(ac_id_in, 'ACID');
1833:
1834: SELECT tmp_ac_id into tmp_ac_id
1835: FROM zpb_cycle_relationships
1836: WHERE published_ac_id = ac_id_in;
1837:
1838: SELECT editable_ac_id into edit_ac_id
1839: FROM zpb_cycle_relationships

Line 1839: FROM zpb_cycle_relationships

1835: FROM zpb_cycle_relationships
1836: WHERE published_ac_id = ac_id_in;
1837:
1838: SELECT editable_ac_id into edit_ac_id
1839: FROM zpb_cycle_relationships
1840: WHERE published_ac_id = ac_id_in;
1841:
1842: ZPB_WF.CallWFAbort(ac_id_in);
1843:

Line 1848: * the ZPB_CYCLE_RELATIONSHIPS table

1844: END IF;
1845:
1846: /*
1847: * If the cycle is an editable copy, then also update
1848: * the ZPB_CYCLE_RELATIONSHIPS table
1849: */
1850: IF cycle_type = 'EDITABLE_COPY' THEN
1851:
1852: SELECT tmp_ac_id into tmp_ac_id

Line 1853: FROM zpb_cycle_relationships

1849: */
1850: IF cycle_type = 'EDITABLE_COPY' THEN
1851:
1852: SELECT tmp_ac_id into tmp_ac_id
1853: FROM zpb_cycle_relationships
1854: WHERE editable_ac_id = ac_id_in;
1855:
1856: UPDATE zpb_cycle_relationships
1857: set editable_ac_id = null,

Line 1856: UPDATE zpb_cycle_relationships

1852: SELECT tmp_ac_id into tmp_ac_id
1853: FROM zpb_cycle_relationships
1854: WHERE editable_ac_id = ac_id_in;
1855:
1856: UPDATE zpb_cycle_relationships
1857: set editable_ac_id = null,
1858: LAST_UPDATED_BY = fnd_global.USER_ID,
1859: LAST_UPDATE_DATE = SYSDATE,
1860: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1867: FROM zpb_cycle_relationships

1863:
1864: IF cycle_type = 'UNPUBLISHED' THEN
1865:
1866: SELECT tmp_ac_id into tmp_ac_id
1867: FROM zpb_cycle_relationships
1868: WHERE editable_ac_id = ac_id_in;
1869:
1870: END IF;
1871:

Line 2053: pet_row_rec zpb_cycle_relationships%ROWTYPE;

2049: x_item_key_out OUT NOCOPY VARCHAR2)
2050: IS
2051: old_published_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2052: ac_rec zpb_analysis_cycles%ROWTYPE;
2053: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2054: published_before VARCHAR2(1);
2055: published_before_status VARCHAR2(30);
2056: enable_option varchar2(30);
2057:

Line 2080: FROM zpb_cycle_relationships

2076: ELSE
2077:
2078: SELECT *
2079: INTO pet_row_rec
2080: FROM zpb_cycle_relationships
2081: WHERE editable_ac_id = editable_ac_id_in;
2082:
2083: IF pet_row_rec.published_ac_id IS NULL THEN
2084: -- SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

Line 2159: UPDATE zpb_cycle_relationships

2155: -- WHERE Analysis_Cycle_Id = old_published_ac_id;
2156:
2157: END IF;
2158:
2159: UPDATE zpb_cycle_relationships
2160: SET published_ac_id = editable_ac_id_in,
2161: editable_ac_id = null,
2162: LAST_UPDATED_BY = fnd_global.USER_ID,
2163: LAST_UPDATE_DATE = SYSDATE,

Line 2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;

2261: editable_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
2262:
2263: IS
2264: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2265: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2266: lock_val zpb_analysis_cycles.locked_by%TYPE;
2267: msg_data VARCHAR2(100);
2268: CURSOR lock_cursor is SELECT locked_by FROM zpb_analysis_cycles
2269: where analysis_cycle_id = lock_ac_id_in FOR UPDATE;

Line 2286: FROM zpb_cycle_relationships

2282: END IF;
2283: END IF;
2284: SELECT *
2285: INTO pet_row_rec
2286: FROM zpb_cycle_relationships
2287: WHERE tmp_ac_id = tmp_ac_id_in;
2288:
2289: IF pet_row_rec.editable_ac_id IS NULL THEN
2290: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

Line 2298: UPDATE zpb_cycle_relationships

2294: END IF;
2295:
2296: create_ac_copy(tmp_ac_id_in, new_ac_id);
2297:
2298: UPDATE zpb_cycle_relationships
2299: SET editable_ac_id = new_ac_id,
2300: LAST_UPDATED_BY = fnd_global.USER_ID,
2301: LAST_UPDATE_DATE = SYSDATE,
2302: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2342: pet_row_rec zpb_cycle_relationships%ROWTYPE;

2338: PROCEDURE get_cycle_type (
2339: ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
2340: cycle_type_out OUT NOCOPY VARCHAR2)
2341: IS
2342: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2343: BEGIN
2344: /*
2345: * We are guaranteed to have only one row returned because of
2346: * the design of the ZPB_CYCLE_RELATIONSHIPS table.

Line 2346: * the design of the ZPB_CYCLE_RELATIONSHIPS table.

2342: pet_row_rec zpb_cycle_relationships%ROWTYPE;
2343: BEGIN
2344: /*
2345: * We are guaranteed to have only one row returned because of
2346: * the design of the ZPB_CYCLE_RELATIONSHIPS table.
2347: */
2348: SELECT *
2349: INTO pet_row_rec
2350: FROM zpb_cycle_relationships

Line 2350: FROM zpb_cycle_relationships

2346: * the design of the ZPB_CYCLE_RELATIONSHIPS table.
2347: */
2348: SELECT *
2349: INTO pet_row_rec
2350: FROM zpb_cycle_relationships
2351: WHERE tmp_ac_id = ac_id_in or
2352: published_ac_id = ac_id_in or
2353: editable_ac_id = ac_id_in;
2354:

Line 2437: SELECT 1 FROM zpb_cycle_relationships

2433: *
2434: */
2435: FUNCTION isTmpDraftOfPublishedBP(p_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) RETURN NUMBER IS
2436: CURSOR c_draft(cp_tmp_ac_id IN zpb_analysis_cycles.analysis_cycle_id%TYPE) IS
2437: SELECT 1 FROM zpb_cycle_relationships
2438: WHERE TMP_AC_ID = cp_tmp_ac_id AND published_ac_id IS NOT NULL;
2439: l_ret NUMBER(2);
2440: BEGIN
2441: OPEN c_draft(cp_tmp_ac_id => p_tmp_ac_id);

Line 2696: pet_rec zpb_cycle_relationships%ROWTYPE;

2692: l_api_version CONSTANT NUMBER := 1.0;
2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
2698: ac_param_rec zpb_ac_param_values%ROWTYPE;
2699: invalid_versions exception;
2700: invalid_calendar_start_type exception;

Line 2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;

2693: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
2698: ac_param_rec zpb_ac_param_values%ROWTYPE;
2699: invalid_versions exception;
2700: invalid_calendar_start_type exception;
2701: invalid_calendar_end_type exception;

Line 2783: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,

2779: pet_rec.CREATION_DATE := SYSDATE;
2780: pet_rec.LAST_UPDATED_BY := p_apps_user_id;
2781: pet_rec.LAST_UPDATE_DATE := SYSDATE;
2782: pet_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
2783: INSERT INTO zpb_cycle_relationships(RELATIONSHIP_ID,
2784: PUBLISHED_AC_ID,
2785: EDITABLE_AC_ID,
2786: TMP_AC_ID,
2787: LAST_UPDATE_LOGIN,