DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_PROC_ORG_HIERARCHY_PVT

Line 1037: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;

1033: x_return_status out nocopy varchar2,
1034: x_msg_count out nocopy number,
1035: x_msg_data out nocopy varchar2)
1036: is
1037: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1038:
1039: begin
1040: l_apo_type.process_id := p_process_id;
1041: l_apo_type.organization_id := p_org_id;

Line 1043: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(

1039: begin
1040: l_apo_type.process_id := p_process_id;
1041: l_apo_type.organization_id := p_org_id;
1042:
1043: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(
1044: p_apo_type => l_apo_type,
1045: p_process_id => p_process_id,
1046: p_top_process_id => null,
1047: p_organization_id => p_org_id,

Line 1074: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;

1070: x_return_status out nocopy varchar2,
1071: x_msg_count out nocopy number,
1072: x_msg_data out nocopy varchar2)
1073: is
1074: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1075:
1076: begin
1077: l_apo_type.process_id := p_process_id;
1078: l_apo_type.organization_id := p_org_id;

Line 1088: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(

1084: fnd_file.put_line(fnd_file.LOG, 'p_organization_id: '||p_org_id);
1085: fnd_file.put_line(fnd_file.LOG, 'p_parent_process_id: '||p_parent_process_id);
1086: fnd_file.put_line(fnd_file.LOG, '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%');
1087:
1088: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(
1089: p_apo_type => l_apo_type,
1090: p_process_id => p_process_id,
1091: p_top_process_id => null,
1092: p_organization_id => p_org_id,

Line 1376: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;

1372: l_next_level number;
1373: x_return_status varchar2(10);
1374: x_msg_count number;
1375: x_msg_data varchar2(2000);
1376: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1377:
1378: cursor c1 (l_pid number, p_oid number) is
1379: select CHILD_PROCESS_ID
1380: from Amw_Process_Org_Relations

Line 1409: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(

1405: l_apo_type.process_id := p_child_process_id;
1406: l_apo_type.organization_id := p_org_id;
1407:
1408:
1409: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(
1410: p_apo_type => l_apo_type,
1411: p_process_id => p_child_process_id,
1412: p_top_process_id => null,
1413: p_organization_id => p_org_id,

Line 1455: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;

1451: x_msg_data out nocopy varchar2) is
1452:
1453: L_API_NAME CONSTANT VARCHAR2(30) := 'disassociate_process_org';
1454:
1455: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1456:
1457: begin
1458:
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1477: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(

1473: where ORGANIZATION_ID = p_org_id
1474: and CHILD_PROCESS_ID = p_process_id;
1475:
1476:
1477: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(
1478: p_apo_type => l_apo_type,
1479: p_process_id => p_process_id,
1480: p_top_process_id => null,
1481: p_organization_id => p_org_id,

Line 1546: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;

1542: l_return_status varchar2(30);
1543: l_msg_count number;
1544: l_msg_data varchar2(4000);
1545:
1546: l_apo_type AMW_PROC_ORG_HIERARCHY_PVT.apo_type;
1547:
1548: begin
1549: -- loop through the org hierarchy and disassociate the children
1550: for c1_rec in c1(p_process_id, p_org_id) loop

Line 1561: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(

1557:
1558: l_apo_type.process_id := c1_rec.CHILD_PROCESS_ID;
1559: l_apo_type.organization_id := p_org_id;
1560:
1561: AMW_PROC_ORG_HIERARCHY_PVT.associate_process_org(
1562: p_apo_type => l_apo_type,
1563: p_process_id => c1_rec.CHILD_PROCESS_ID,
1564: p_top_process_id => null,
1565: p_organization_id => p_org_id,