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.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_TRAINING_PLANS

Line 1263: FROM ota_training_plans tps

1259: ,tps.ATTRIBUTE24 ,tps.ATTRIBUTE25
1260: ,tps.ATTRIBUTE26 ,tps.ATTRIBUTE27
1261: ,tps.ATTRIBUTE28 ,tps.ATTRIBUTE29
1262: ,tps.ATTRIBUTE30 ,tps.creator_person_id
1263: FROM ota_training_plans tps
1264: WHERE tps.plan_source NOT IN ('TALENT_MGMT','CATALOG')
1265: AND (tps.PERSON_ID is not NULL OR contact_id is not null)
1266: AND tps.learning_path_id is null
1267: AND tps.training_plan_id between p_start_pkid AND p_end_pkid;

Line 1482: from ota_training_plans

1478:
1479: END LOOP;
1480: Select nvl(count(1),0)
1481: into l_rows_processed
1482: from ota_training_plans
1483: where training_plan_id between p_start_pkid and p_end_pkid;
1484:
1485: p_rows_processed := l_rows_processed;
1486: end upg_tp_for_lrnr_and_mgr_to_lp;

Line 1538: FROM ota_training_plans tps,Ota_training_plan_members tpm

1534:
1535:
1536: cursor csr_get_talent_mgmt_comb is
1537: SELECT distinct Tpm.source_id,Tpm.source_function, Tpm.assignment_id, tps.person_id
1538: FROM ota_training_plans tps,Ota_training_plan_members tpm
1539: WHERE PLAN_SOURCE = 'TALENT_MGMT'
1540: AND tpm.training_plan_id = tps.training_plan_id
1541: AND tps.PERSON_ID is not NULL;
1542:

Line 1628: FROM ota_training_plans tps, Ota_training_plan_members tpm

1624: ,tps.ATTRIBUTE27 tps_attribute27
1625: ,tps.ATTRIBUTE28 tps_attribute28
1626: ,tps.ATTRIBUTE29 tps_attribute29
1627: ,tps.ATTRIBUTE30 tps_ATTRIBUTE30
1628: FROM ota_training_plans tps, Ota_training_plan_members tpm
1629: WHERE tps.PLAN_SOURCE = 'TALENT_MGMT'
1630: AND tps.PERSON_ID = p_person_id
1631: --AND PERSON_ID is not NULL
1632: AND tpm.training_plan_id = tps.training_plan_id

Line 1642: FROM Ota_training_plan_members tpm, ota_training_plans tps

1638: cursor csr_member_status (p_source_id in number
1639: ,p_source_function in varchar2, p_assignment_id in number, p_person_id IN NUMBER) is
1640: SELECT decode(member_status_type_id, 'OTA_PLANNED', 0,'ACTIVE', 0, 'OTA_AWAITING_APPROVAL',0, 'OTA_COMPLETED',1,
1641: 'CANCELLED',2) top_status
1642: FROM Ota_training_plan_members tpm, ota_training_plans tps
1643: WHERE tps.training_plan_id = tpm.training_plan_id
1644: AND tpm.source_function = p_source_function
1645: AND (tpm.source_id is null or tpm.source_id = p_source_id)
1646: AND (tpm.assignment_id is null or tpm.assignment_id = p_assignment_id)

Line 1906: from ota_training_plans

1902: END LOOP;
1903:
1904: Select nvl(count(1),0)
1905: into l_rows_processed
1906: from ota_training_plans
1907: where training_plan_id between p_start_pkid and p_end_pkid;
1908:
1909: p_rows_processed := l_rows_processed;
1910: end upg_tp_to_lp_for_talent_mgmt;

Line 1960: FROM ota_training_plans tp

1956: ,tp.ATTRIBUTE24 ,tp.ATTRIBUTE25
1957: ,tp.ATTRIBUTE26 ,tp.ATTRIBUTE27
1958: ,tp.ATTRIBUTE28 ,tp.ATTRIBUTE29
1959: ,tp.ATTRIBUTE30 ,tp.creator_person_id
1960: FROM ota_training_plans tp
1961: WHERE tp.PLAN_SOURCE in ('CATALOG','MANAGER')
1962: AND tp.learning_path_id is not null
1963: AND (tp.PERSON_ID is not NULL OR tp.contact_id is not null)
1964: AND tp.training_plan_id between p_start_pkid and p_end_pkid;

Line 1993: ota_training_plans tp,

1989: ,tpm.ATTRIBUTE26 ,tpm.ATTRIBUTE27
1990: ,tpm.ATTRIBUTE28 ,tpm.ATTRIBUTE29
1991: ,tpm.ATTRIBUTE30
1992: FROM ota_training_plan_members tpm,
1993: ota_training_plans tp,
1994: ota_learning_path_members lpm,
1995: ota_learning_paths lps
1996: WHERE tp.training_plan_id = p_training_plan_id
1997: AND lpm.activity_version_id = tpm.activity_version_id

Line 2128: from ota_training_plans

2124:
2125: END LOOP;
2126: Select nvl(count(1),0)
2127: into l_rows_processed
2128: from ota_training_plans
2129: where training_plan_id between p_start_pkid and p_end_pkid;
2130:
2131: p_rows_processed := l_rows_processed;
2132: end upg_enrol_to_cat_lp;

Line 2282: FROM ota_training_plans tps

2278: AND lpme.lp_enrollment_id = p_lp_enrollment_id;
2279:
2280: Cursor csr_get_attrib_personal_tps is
2281: SELECT 1
2282: FROM ota_training_plans tps
2283: WHERE (tps.PERSON_ID is not NULL OR tps.contact_id is not null)
2284: and (tps.ATTRIBUTE_CATEGORY||tps.ATTRIBUTE1||tps.ATTRIBUTE2||tps.ATTRIBUTE3||tps.ATTRIBUTE4||
2285: tps.ATTRIBUTE5||tps.ATTRIBUTE6||tps.ATTRIBUTE7 ||tps.ATTRIBUTE9||tps.ATTRIBUTE10||tps.ATTRIBUTE11||
2286: tps.ATTRIBUTE12||tps.ATTRIBUTE13||tps.ATTRIBUTE14||tps.ATTRIBUTE15||tps.ATTRIBUTE16 ||

Line 2294: FROM ota_training_plan_members tpm, ota_training_plans tps

2290: AND ROWNUM=1;
2291:
2292: Cursor csr_get_attrib_personal_tpm is
2293: SELECT 1
2294: FROM ota_training_plan_members tpm, ota_training_plans tps
2295: WHERE (tps.PERSON_ID is not NULL OR contact_id is not null)
2296: AND (TPM.ATTRIBUTE_CATEGORY||TPM.ATTRIBUTE1||TPM.ATTRIBUTE2||TPM.ATTRIBUTE3||TPM.ATTRIBUTE4||
2297: TPM.ATTRIBUTE5||TPM.ATTRIBUTE6||TPM.ATTRIBUTE7 ||TPM.ATTRIBUTE9||TPM.ATTRIBUTE10||TPM.ATTRIBUTE11||
2298: TPM.ATTRIBUTE12||TPM.ATTRIBUTE13||TPM.ATTRIBUTE14||TPM.ATTRIBUTE15||TPM.ATTRIBUTE16 ||

Line 2439: migrate_dff_contexts('OTA_TRAINING_PLANS','OTA_LP_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);

2435: /* Create DFF context for LPE from personal TPS */
2436: Open csr_get_attrib_personal_tps;
2437: Fetch csr_get_attrib_personal_tps into l_flex_val;
2438: if l_flex_val is not null then
2439: migrate_dff_contexts('OTA_TRAINING_PLANS','OTA_LP_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);
2440: end if;
2441: Close csr_get_attrib_personal_tps;
2442: /* Create DFF context for LPME from personal TPM */
2443: Open csr_get_attrib_personal_tpm;