APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on BIS_CORRECTIVE_ACTION_PUB

Line 332: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_GEN_WORKFLOW_ITEM_TYPE;

328: IS
329:
330: l_wf_item_key NUMBER;
331: l_item_type VARCHAR2(32000)
332: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_GEN_WORKFLOW_ITEM_TYPE;
333: l_process VARCHAR2(32000)
334: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_ALR_WORKFLOW_PROCESS;
335:
336: l_Alert_recipients_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;

Line 334: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_ALR_WORKFLOW_PROCESS;

330: l_wf_item_key NUMBER;
331: l_item_type VARCHAR2(32000)
332: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_GEN_WORKFLOW_ITEM_TYPE;
333: l_process VARCHAR2(32000)
334: := BIS_CORRECTIVE_ACTION_PUB.G_BIS_ALR_WORKFLOW_PROCESS;
335:
336: l_Alert_recipients_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
337: l_Alert_recipients_sh_nm_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
338:

Line 1623: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE1

1619: );
1620: l_sent_Date := getdate; -- to_char(sysdate,'DD-MON-YYYY HH24:MM:SS'); -- 2837974
1621:
1622: IF
1623: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE1
1624: THEN
1625: l_notify := l_target_rec.Notify_Resp1_Name;
1626: ELSIF
1627: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE2

Line 1627: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE2

1623: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE1
1624: THEN
1625: l_notify := l_target_rec.Notify_Resp1_Name;
1626: ELSIF
1627: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE2
1628: THEN
1629: l_notify := l_target_rec.Notify_Resp2_Name;
1630: ELSIF
1631: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE3

Line 1631: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE3

1627: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE2
1628: THEN
1629: l_notify := l_target_rec.Notify_Resp2_Name;
1630: ELSIF
1631: p_comparison_result = BIS_CORRECTIVE_ACTION_PUB.G_MSG_TYPE_EXCEPTION_RANGE3
1632: THEN
1633: l_notify := l_target_rec.Notify_Resp3_Name;
1634: END IF;
1635: