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.AHL_PC_HEADER_PVT dependencies on AHL_PC_HEADER_PVT

Line 1: PACKAGE BODY AHL_PC_HEADER_PVT AS

1: PACKAGE BODY AHL_PC_HEADER_PVT AS
2: /* $Header: AHLVPCHB.pls 120.5.12010000.2 2008/11/28 04:55:27 skpathak ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
5:

Line 143: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_CREATE

139: IF G_DEBUG='Y' THEN
140: AHL_DEBUG_PUB.ENABLE_DEBUG;
141: END IF;
142:
143: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_CREATE
144: THEN
145: p_x_pc_header_rec.PC_HEADER_ID :=0;
146: END IF;
147:

Line 161: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK

157: -- Insert Record into ahl_pc_header_headers,
158: -- call table handler insert record
159: SELECT AHL_PC_HEADERS_B_S.NEXTVAL INTO l_header_id FROM DUAL;
160:
161: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
162: THEN
163: l_link_id := p_x_pc_header_rec.LINK_TO_PC_ID;
164: END IF;
165:

Line 341: IF p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_LINK

337: INTO p_x_pc_header_rec.LINK_TO_PC_ID
338: FROM AHL_PC_HEADERS_VL
339: WHERE PC_HEADER_ID = p_x_pc_header_rec.PC_HEADER_ID;
340:
341: IF p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_LINK
342: THEN
343: VALIDATE_PC_HEADER (p_x_pc_header_rec => p_x_pc_header_rec);
344:
345: VALIDATE_PC_HEADER_UPDATE

Line 361: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK

357: IF G_DEBUG='Y' THEN
358: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- Operation Flag after VALIDATE_PC_HEADER_UPDATE = '||p_x_pc_header_rec.OPERATION_FLAG);
359: END IF;
360:
361: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
362: THEN
363: -- Check Error Message stack.
364: x_msg_count := FND_MSG_PUB.count_msg;
365: IF x_msg_count > 0

Line 930: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

926: AHL_DEBUG_PUB.ENABLE_DEBUG;
927: END IF;
928:
929: l_old_header_id := p_x_pc_header_rec.PC_HEADER_ID;
930: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
931:
932: -- Check whether another PC with the same name exists, throw error in that case
933: OPEN check_name_unique( p_x_pc_header_rec.name );
934: FETCH check_name_unique INTO l_dummy_2;

Line 1016: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;

1012: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
1013: l_node_rec.DRAFT_FLAG := 'N';
1014: l_node_rec.LINK_TO_NODE_ID := 0;
1015: l_node_rec.OBJECT_VERSION_NUMBER := 1;
1016: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;
1017: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1018: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1019: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
1020: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 1044: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;

1040: l_assos_rec.INVENTORY_ORG_ID := l_node_data_rec.INVENTORY_ORG_ID;
1041: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec.node_type;
1042: l_assos_rec.DRAFT_FLAG := 'N';
1043: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
1044: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_COPY;
1045: l_assos_rec.OBJECT_VERSION_NUMBER := 1;
1046: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1047: l_assos_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1048: l_assos_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;

Line 1466: IF p_x_pc_header_rec.OPERATION_FLAG NOT IN (AHL_PC_HEADER_PVT.G_DML_DELETE) THEN

1462:
1463:
1464: BEGIN
1465:
1466: IF p_x_pc_header_rec.OPERATION_FLAG NOT IN (AHL_PC_HEADER_PVT.G_DML_DELETE) THEN
1467:
1468: -- CHECK NAME UNIQUE
1469: OPEN check_name(p_pc_header_id => p_x_pc_header_rec.PC_HEADER_ID,
1470: p_name => p_x_pc_header_rec.NAME,

Line 1776: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

1772:
1773: p_x_pc_header_rec.LINK_TO_PC_ID := l_old_header_id;
1774: p_x_pc_header_rec.DRAFT_FLAG := 'N';
1775: p_x_pc_header_rec.STATUS := 'DRAFT';
1776: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1777:
1778: CREATE_PC_HEADER
1779: (
1780: p_api_version => p_api_version,

Line 1817: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

1813: l_node_rec.PARENT_NODE_ID := l_node_data_rec.PARENT_NODE_ID;
1814: l_node_rec.CHILD_COUNT := l_node_data_rec.CHILD_COUNT;
1815: l_node_rec.NAME := l_node_data_rec.NAME;
1816: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
1817: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1818: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec.OBJECT_VERSION_NUMBER;
1819: l_node_rec.DRAFT_FLAG := 'N';
1820: l_node_rec.LINK_TO_NODE_ID := l_node_data_rec.PC_NODE_ID;
1821: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

Line 1821: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

1817: l_node_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1818: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec.OBJECT_VERSION_NUMBER;
1819: l_node_rec.DRAFT_FLAG := 'N';
1820: l_node_rec.LINK_TO_NODE_ID := l_node_data_rec.PC_NODE_ID;
1821: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1822: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1823: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1824: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
1825: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 1852: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;

1848: l_assos_rec.PC_ASSOCIATION_ID := l_node_data_rec.PC_NODE_ID;
1849: l_assos_rec.UNIT_ITEM_ID := l_node_data_rec.UNIT_ITEM_ID;
1850: l_assos_rec.INVENTORY_ORG_ID := l_node_data_rec.INVENTORY_ORG_ID;
1851: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec.NODE_TYPE;
1852: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1853: l_assos_rec.DRAFT_FLAG := 'N';
1854: l_assos_rec.LINK_TO_ASSOCIATION_ID := l_node_data_rec.PC_NODE_ID;
1855: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1856: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;

Line 1855: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

1851: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec.NODE_TYPE;
1852: l_assos_rec.OPERATION_STATUS_FLAG := AHL_PC_HEADER_PVT.G_DML_CREATE;
1853: l_assos_rec.DRAFT_FLAG := 'N';
1854: l_assos_rec.LINK_TO_ASSOCIATION_ID := l_node_data_rec.PC_NODE_ID;
1855: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
1856: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
1857: l_assos_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
1858: l_assos_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
1859: l_assos_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 2699: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

2695:
2696: p_x_pc_header_rec.PC_HEADER_ID := l_pc_header_rec.LINK_TO_PC_ID;
2697: p_x_pc_header_rec.LINK_TO_PC_ID := 0;
2698: p_x_pc_header_rec.DRAFT_FLAG := 'N';
2699: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2700:
2701: SELECT OBJECT_VERSION_NUMBER INTO p_x_pc_header_rec.OBJECT_VERSION_NUMBER
2702: FROM AHL_PC_HEADERS_B
2703: WHERE PC_HEADER_ID = l_pc_header_rec.LINK_TO_PC_ID;

Line 2706: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2702: FROM AHL_PC_HEADERS_B
2703: WHERE PC_HEADER_ID = l_pc_header_rec.LINK_TO_PC_ID;
2704:
2705: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2707: 'About to call UPDATE_PC_HEADER with p_x_pc_header_rec.PC_HEADER_ID = ' || p_x_pc_header_rec.PC_HEADER_ID);
2708: END IF;
2709:
2710: UPDATE_PC_HEADER

Line 2724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2720: );
2721:
2722:
2723: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2725: 'Returned from UPDATE_PC_HEADER with x_return_status = ' || x_return_status);
2726: END IF;
2727:
2728:

Line 2764: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2760: l_node_rec.NAME := l_node_data_rec_det.NAME;
2761: l_node_rec.DESCRIPTION := l_node_data_rec_det.DESCRIPTION;
2762: l_node_rec.DRAFT_FLAG := 'N';
2763: l_node_rec.LINK_TO_NODE_ID := 0;
2764: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2765: l_node_rec.OBJECT_VERSION_NUMBER := l_node_data_rec_det.OBJECT_VERSION_NUMBER;
2766:
2767: ELSIF l_node_data_rec_det.node_type IN (G_PART, G_UNIT)
2768: THEN

Line 2777: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2773: l_assos_rec.INVENTORY_ORG_ID := l_node_data_rec_det.INVENTORY_ORG_ID;
2774: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec_det.node_type;
2775: l_assos_rec.DRAFT_FLAG := 'N';
2776: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
2777: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2778: l_assos_rec.OBJECT_VERSION_NUMBER := l_node_data_rec_det.OBJECT_VERSION_NUMBER;
2779:
2780: END IF;
2781:

Line 2799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2795: END LOOP;
2796: CLOSE detach_nodes;
2797:
2798: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2799: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2800: 'Completed detach_nodes loop');
2801: END IF;
2802:
2803: -- Added to delete those associations which has association id, node id and header id the same

Line 2819: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

2815: l_assos_rec.INVENTORY_ORG_ID := l_asso_data_rec_det.INVENTORY_ORG_ID;
2816: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_asso_data_rec_det.ASSOCIATION_TYPE_FLAG;
2817: l_assos_rec.DRAFT_FLAG := 'N';
2818: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
2819: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
2820: l_assos_rec.OBJECT_VERSION_NUMBER := l_asso_data_rec_det.OBJECT_VERSION_NUMBER;
2821:
2822: END IF;
2823:

Line 2837: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2833: END LOOP;
2834: CLOSE detach_associations;
2835:
2836: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2837: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2838: 'Completed detach_associations loop');
2839: END IF;
2840:
2841:

Line 2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2855: FETCH attach_nodes INTO l_node_data_rec;
2856: EXIT WHEN attach_nodes%NOTFOUND;
2857:
2858: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2860: 'In attach_nodes loop. l_node_data_rec.node_type = ' || l_node_data_rec.node_type ||
2861: ', l_node_data_rec.PC_NODE_ID = ' || l_node_data_rec.PC_NODE_ID ||
2862: ', l_node_data_rec.LINK_TO_NODE_ID = ' || l_node_data_rec.LINK_TO_NODE_ID);
2863: END IF;

Line 2886: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

2882: l_node_rec.NAME := l_node_data_rec.NAME;
2883: l_node_rec.DESCRIPTION := l_node_data_rec.DESCRIPTION;
2884: l_node_rec.DRAFT_FLAG := 'N';
2885: l_node_rec.LINK_TO_NODE_ID := 0;
2886: l_node_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2887: l_node_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
2888: l_node_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
2889: l_node_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
2890: l_node_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',

2905: FROM AHL_PC_NODES_B
2906: WHERE PC_NODE_ID = l_node_rec.PC_NODE_ID;
2907:
2908: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.AHL_PC_HEADER_PVT.REMOVE_LINK',
2910: 'Got l_node_rec.OBJECT_VERSION_NUMBER as ' || l_node_rec.OBJECT_VERSION_NUMBER);
2911: END IF;
2912:
2913: ELSIF l_node_data_rec.node_type IN (G_PART, G_UNIT)

Line 2932: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

2928: l_assos_rec.INVENTORY_ORG_ID := l_node_data_rec.INVENTORY_ORG_ID;
2929: l_assos_rec.ASSOCIATION_TYPE_FLAG := l_node_data_rec.NODE_TYPE;
2930: l_assos_rec.DRAFT_FLAG := 'N';
2931: l_assos_rec.LINK_TO_ASSOCIATION_ID := 0;
2932: l_assos_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
2933: l_assos_rec.ATTRIBUTE_CATEGORY := l_node_data_rec.ATTRIBUTE_CATEGORY;
2934: l_assos_rec.ATTRIBUTE1 := l_node_data_rec.ATTRIBUTE1;
2935: l_assos_rec.ATTRIBUTE2 := l_node_data_rec.ATTRIBUTE2;
2936: l_assos_rec.ATTRIBUTE3 := l_node_data_rec.ATTRIBUTE3;

Line 3096: l_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;

3092: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Docs Merge ends');
3093: END IF;
3094:
3095:
3096: l_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_DELETE;
3097:
3098: DELETE_PC_AND_TREE(l_pc_header_rec.pc_header_id);
3099:
3100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3104: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;

3100: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,' Deleted Header Record');
3102: END IF;
3103:
3104: p_x_pc_header_rec.OPERATION_FLAG := AHL_PC_HEADER_PVT.G_DML_LINK;
3105:
3106: -- SATHAPLI::Bug# 6504069, 26-Mar-2008
3107: -- The call to API AHL_UMP_UNITMAINT_PVT.PROCESS_UNITEFFECTIVITY for building
3108: -- unit effectivities has been commented out for performance reasons.

Line 3523: END AHL_PC_HEADER_PVT;

3519: END IF;
3520:
3521: END VALIDATE_PC_HEADER_UPDATE;
3522:
3523: END AHL_PC_HEADER_PVT;