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 1167: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;

1163: WHERE unit_deferral_id = p_unit_deferral_id;
1164:
1165: l_unit_effectivity_id NUMBER;
1166:
1167: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
1168: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
1169:
1170: BEGIN
1171:

Line 1168: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;

1164:
1165: l_unit_effectivity_id NUMBER;
1166:
1167: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
1168: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
1169:
1170: BEGIN
1171:
1172: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1245: AHL_PRD_DF_PVT.process_approval_approved(

1241: itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => 'NEW_STATUS_ID'
1244: );
1245: AHL_PRD_DF_PVT.process_approval_approved(
1246: p_unit_deferral_id => l_object_id,
1247: p_object_version_number => l_object_version_number,
1248: p_new_status => l_new_status,
1249: x_return_status => l_return_status

Line 1262: AHL_PRD_DF_PVT.get_deferral_details (

1258: FND_MSG_PUB.ADD;
1259: CLOSE unit_effectivity_id_csr;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: ELSE
1262: AHL_PRD_DF_PVT.get_deferral_details (
1263: p_init_msg_list => FND_API.G_FALSE,
1264: p_unit_effectivity_id => l_unit_effectivity_id,
1265: x_df_header_info_rec => l_df_header_info_rec,
1266: x_df_schedules_tbl => l_df_schedules_tbl,

Line 1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND

1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSE
1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND
1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:
1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');
1280: l_msg_data := FND_MESSAGE.get;

Line 1288: AHL_PRD_DF_PVT.process_approval_rejected(

1284: WHERE unit_deferral_id = l_object_id
1285: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1286:
1287: l_new_status := 'DEFERRAL_REJECTED';
1288: AHL_PRD_DF_PVT.process_approval_rejected(
1289: p_unit_deferral_id => l_object_id,
1290: p_object_version_number => l_object_version_number,
1291: p_new_status => l_new_status,
1292: x_return_status => l_return_status

Line 1302: AHL_PRD_DF_PVT.process_approval_approved(

1298: itemtype => itemtype,
1299: itemkey => itemkey,
1300: aname => 'NEW_STATUS_ID'
1301: );
1302: AHL_PRD_DF_PVT.process_approval_approved(
1303: p_unit_deferral_id => l_object_id,
1304: p_object_version_number => l_object_version_number,
1305: p_new_status => l_new_status,
1306: x_return_status => l_return_status

Line 1320: AHL_PRD_DF_PVT.process_approval_rejected(

1316: itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'REJECT_STATUS_ID'
1319: );
1320: AHL_PRD_DF_PVT.process_approval_rejected(
1321: p_unit_deferral_id => l_object_id,
1322: p_object_version_number => l_object_version_number,
1323: p_new_status => l_new_status,
1324: x_return_status => l_return_status

Line 1513: AHL_PRD_DF_PVT.process_approval_rejected(

1509: );
1510:
1511: END IF;
1512: -- go in error mode
1513: AHL_PRD_DF_PVT.process_approval_rejected(
1514: p_unit_deferral_id => l_object_id,
1515: p_object_version_number => l_object_version_number,
1516: p_new_status => l_orig_status,
1517: x_return_status => l_return_status

Line 1605: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,

1601:
1602: END Revert_Status;
1603:
1604: FUNCTION getRequesterNote(
1605: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
1606: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS
1607:
1608: l_requester_note VARCHAR2(4000);
1609: l_defer_to_meaning VARCHAR2(80);

Line 1606: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS

1602: END Revert_Status;
1603:
1604: FUNCTION getRequesterNote(
1605: p_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type,
1606: p_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type) RETURN VARCHAR2 IS
1607:
1608: l_requester_note VARCHAR2(4000);
1609: l_defer_to_meaning VARCHAR2(80);
1610: l_defer_by_meaning VARCHAR2(80);

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

1617: BEGIN
1618: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CTXT_TITLE');
1619: l_requester_note := FND_MESSAGE.get;
1620:
1621: IF(p_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
1622: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_CTXT');
1623: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_df_header_info_rec.mr_title,false);
1624: FND_MESSAGE.SET_TOKEN('VISIT_NUMBER',p_df_header_info_rec.visit_number,false);
1625: FND_MESSAGE.SET_TOKEN('MR_DESC',p_df_header_info_rec.mr_description,false);

Line 1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

1643: l_requester_note := l_requester_note || FND_MESSAGE.get;
1644:
1645: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SCHEDULE');
1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');

Line 1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN

1646: l_requester_note := l_requester_note || FND_MESSAGE.get;
1647: IF(NVL(p_df_header_info_rec.cancel_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1648: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CANCEL');
1649: l_requester_note := l_requester_note || FND_MESSAGE.get;
1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: 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

Line 1654: 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

1650: ELSIF (NVL(p_df_header_info_rec.skip_mr_flag,AHL_PRD_DF_PVT.G_NO_FLAG) = AHL_PRD_DF_PVT.G_YES_FLAG)THEN
1651: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_SKIP');
1652: l_requester_note := l_requester_note || FND_MESSAGE.get;
1653: ELSE
1654: 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
1655: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_AFFDUE');
1656: l_requester_note := l_requester_note || FND_MESSAGE.get;
1657: END IF;
1658: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_DFR_TODT');

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

1667: l_requester_note := l_requester_note || FND_MESSAGE.get;
1668:
1669: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1670: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1671: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1672: l_defer_by_meaning := meaning_rec.meaning;
1673: ELSIF (meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1674: l_defer_to_meaning := meaning_rec.meaning;
1675: END IF;

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

1669: IF(p_df_schedules_tbl IS NOT NULL AND p_df_schedules_tbl.count > 0)THEN
1670: FOR meaning_rec IN ctr_value_type_meaning_csr LOOP
1671: IF(meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1672: l_defer_by_meaning := meaning_rec.meaning;
1673: ELSIF (meaning_rec.lookup_code = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1674: l_defer_to_meaning := meaning_rec.meaning;
1675: END IF;
1676: END LOOP;
1677:

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

1677:
1678: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;

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

1679: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CNT_ROW');
1680: FND_MESSAGE.SET_TOKEN('COUNTER_NAME',p_df_schedules_tbl(i).counter_name,false);
1681: IF(p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_BY)THEN
1682: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_by_meaning,false);
1683: ELSIF (p_df_schedules_tbl(i).CTR_VALUE_TYPE_CODE = AHL_PRD_DF_PVT.G_DEFER_TO)THEN
1684: FND_MESSAGE.SET_TOKEN('CTR_VAL_TYPE_CODE',l_defer_to_meaning,false);
1685: END IF;
1686: FND_MESSAGE.SET_TOKEN('COUNTER_VALUE',p_df_schedules_tbl(i).counter_value,false);
1687: FND_MESSAGE.SET_TOKEN('UOM_CODE',p_df_schedules_tbl(i).unit_of_measure,false);

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

1715: IF(p_defer_reason_code IS NULL)THEN
1716: RETURN l_return_meaning;
1717: END IF;
1718: LOOP
1719: l_temp2 := instr(p_defer_reason_code,AHL_PRD_DF_PVT.G_REASON_CODE_DELIM,1,l_index);
1720: IF(l_temp2 = 0) THEN
1721: l_string := substr(p_defer_reason_code,l_temp1);
1722: OPEN val_reason_meaning_csr(l_string);
1723: FETCH val_reason_meaning_csr INTO l_meaning;