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_PRD_DF_APPR_PVT dependencies on AHL_PRD_DF_PVT

Line 8: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,

4: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
5: G_WORKFLOW_OBJECT_KEY CONSTANT VARCHAR2(30) := 'PRDWF';
6:
7: FUNCTION getRequesterNote(
8: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
9: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type)RETURN VARCHAR2;
10:
11: FUNCTION getReasonCode(p_defer_reason_code IN VARCHAR2) RETURN VARCHAR2;
12:

Line 9: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type)RETURN VARCHAR2;

5: G_WORKFLOW_OBJECT_KEY CONSTANT VARCHAR2(30) := 'PRDWF';
6:
7: FUNCTION getRequesterNote(
8: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
9: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type)RETURN VARCHAR2;
10:
11: FUNCTION getReasonCode(p_defer_reason_code IN VARCHAR2) RETURN VARCHAR2;
12:
13: --------------------------------------------------------------------------------

Line 43: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;

39:
40: l_approver VARCHAR2(30);
41: l_requester VARCHAR2(30);
42:
43: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
44: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
45:
46: CURSOR unit_effectivity_id_csr(p_unit_deferral_id IN NUMBER) IS
47: SELECT unit_effectivity_id from ahl_unit_deferrals_b

Line 44: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;

40: l_approver VARCHAR2(30);
41: l_requester VARCHAR2(30);
42:
43: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
44: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
45:
46: CURSOR unit_effectivity_id_csr(p_unit_deferral_id IN NUMBER) IS
47: SELECT unit_effectivity_id from ahl_unit_deferrals_b
48: WHERE unit_deferral_id = p_unit_deferral_id;

Line 108: AHL_PRD_DF_PVT.get_deferral_details (

104: END IF;
105: CLOSE unit_effectivity_id_csr;
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSE
108: AHL_PRD_DF_PVT.get_deferral_details (
109: p_init_msg_list => FND_API.G_FALSE,
110: p_unit_effectivity_id => l_unit_effectivity_id,
111: x_df_header_info_rec => l_df_header_info_rec,
112: x_df_schedules_tbl => l_df_schedules_tbl,

Line 130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN

126: );
127: END IF;
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSE
130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);
133: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',l_df_header_info_rec.visit_number,false);
134: l_temp_subject := FND_MESSAGE.get;

Line 1236: AHL_PRD_DF_PVT.process_approval_approved(

1232: itemtype => itemtype,
1233: itemkey => itemkey,
1234: aname => 'NEW_STATUS_ID'
1235: );
1236: AHL_PRD_DF_PVT.process_approval_approved(
1237: p_unit_deferral_id => l_object_id,
1238: p_object_version_number => l_object_version_number,
1239: p_new_status => l_new_status,
1240: x_return_status => l_return_status

Line 1248: AHL_PRD_DF_PVT.process_approval_rejected(

1244: itemtype => itemtype,
1245: itemkey => itemkey,
1246: aname => 'REJECT_STATUS_ID'
1247: );
1248: AHL_PRD_DF_PVT.process_approval_rejected(
1249: p_unit_deferral_id => l_object_id,
1250: p_object_version_number => l_object_version_number,
1251: p_new_status => l_new_status,
1252: x_return_status => l_return_status

Line 1441: AHL_PRD_DF_PVT.process_approval_rejected(

1437: );
1438:
1439: END IF;
1440: -- go in error mode
1441: AHL_PRD_DF_PVT.process_approval_rejected(
1442: p_unit_deferral_id => l_object_id,
1443: p_object_version_number => l_object_version_number,
1444: p_new_status => l_orig_status,
1445: x_return_status => l_return_status

Line 1533: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,

1529:
1530: END Revert_Status;
1531:
1532: FUNCTION getRequesterNote(
1533: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
1534: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS
1535:
1536: l_requester_note VARCHAR2(4000);
1537: l_defer_to_meaning VARCHAR2(80);

Line 1534: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS

1530: END Revert_Status;
1531:
1532: FUNCTION getRequesterNote(
1533: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
1534: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS
1535:
1536: l_requester_note VARCHAR2(4000);
1537: l_defer_to_meaning VARCHAR2(80);
1538: l_defer_by_meaning VARCHAR2(80);

Line 1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN

1545: BEGIN
1546: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1547: l_requester_note := FND_MESSAGE.get;
1548:
1549: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1551: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1552: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1553: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);

Line 1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

1571: l_requester_note := l_requester_note || FND_MESSAGE.get;
1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE

Line 1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN

1572:
1573: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1574: l_requester_note := l_requester_note || FND_MESSAGE.get;
1575: IF(NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1576: IF(NVL(p_df_header_info_rec.manually_planned_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_NO_FLAG)THEN
1577: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1578: l_requester_note := l_requester_note || FND_MESSAGE.get;
1579: ELSE
1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');

Line 1584: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

1580: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1581: l_requester_note := l_requester_note || FND_MESSAGE.get;
1582: END IF;
1583: ELSE
1584: IF(NVL(p_df_header_info_rec.affect_due_calc_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1586: l_requester_note := l_requester_note || FND_MESSAGE.get;
1587: END IF;
1588: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');

Line 1601: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN

1597: l_requester_note := l_requester_note || FND_MESSAGE.get;
1598:
1599: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1600: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1601: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1602: l_defer_by_meaning := meaning_rec.meaning;
1603: ELSIF (meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1604: l_defer_to_meaning := meaning_rec.meaning;
1605: END IF;

Line 1603: ELSIF (meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_TO)THEN

1599: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1600: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1601: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1602: l_defer_by_meaning := meaning_rec.meaning;
1603: ELSIF (meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1604: l_defer_to_meaning := meaning_rec.meaning;
1605: END IF;
1606: END LOOP;
1607:

Line 1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN

1607:
1608: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1609: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;

Line 1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN

1609: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1610: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1611: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1612: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1613: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1614: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1615: END IF;
1616: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1617: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);

Line 1649: l_temp2 := instr(p_defer_reason_code,AHL_PRD_DF_PVT.G_REASON_CODE_DELIM,1,l_index);

1645: IF(p_defer_reason_code IS NULL)THEN
1646: RETURN l_return_meaning;
1647: END IF;
1648: LOOP
1649: l_temp2 := instr(p_defer_reason_code,AHL_PRD_DF_PVT.G_REASON_CODE_DELIM,1,l_index);
1650: IF(l_temp2 = 0) THEN
1651: l_string := substr(p_defer_reason_code,l_temp1);
1652: OPEN val_reason_meaning_csr(l_string);
1653: FETCH val_reason_meaning_csr INTO l_meaning;