1 PACKAGE PO_NOTIF_CONTROLS_SV AS
2 /*$Header: POXPONCS.pls 120.0.12010000.1 2008/09/18 12:21:01 appldev noship $*/
3 /*===========================================================================
4 PROCEDURE NAME: delete_notifs()
5
6 DESCRIPTION:
7 - Delete children when deleting header;
8 po lines all po line locations all po distributions planned
9 /std po notification controls planned/blanket
10 - Delete children when deleting header;
11 po lines al po line locations all po distribution planned/
12 std po notification controls planned/blanket po
13 notifications
14 [DEBUG; DELETE_NOTIFICATIONS]
15 attachements
16 [DEBUG; DELETE_ATTACHMENTS]
17
18 - Update po_requisition_lines to remove the link to
19 the shipment if you are deleting a standard or planned PO
20
21 UPDATE po_requisition_lines
22 SET line_location_id = NULL
23 WHERE line_location_id in (SELECT line_location_id
24 FROM po_line_locations
25 WHERE po_header_id = Delete_Me.po_header_id)
26
27 Refer Closed Issue #3.
28 PARAMETERS:
29
30 DESIGN REFERENCES: ../POXPOMPO.doc
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY:
41 ===========================================================================*/
42
43 FUNCTION delete_notifs(X_po_header_id IN number)
44 return boolean;
45
46 /*===========================================================================
47 FUNCTION NAME: val_notif_controls()
48
49 DESCRIPTION: This procedure checks amount based notification
50 control records for a planned, contract and
51 blanket purchase order. If there are any amount
52 based control exist, it return TRUE to the caller.
53
54 PARAMETERS:
55
56 DESIGN REFERENCES: ../POXPOMPO.doc
57
58 ALGORITHM:
59
60 NOTES:
61
62 OPEN ISSUES:
63
64 CLOSED ISSUES:
65
66 CHANGE HISTORY: 11/13/95 WLAU created.
67 ===========================================================================*/
68
69 FUNCTION val_notif_controls (X_po_header_id number)
70 return boolean;
71
72 /*===========================================================================
73 FUNCTION NAME: val_date_notif()
74
75 DESCRIPTION:
76 o VAL - check the notification controls when this field is changed.
77 If there are any date based controls , display the error
78 message PO_PO_NFC_DATE_CONTROLS_EXIST. This returns failu
79 o VAL - check the notification controls when this field is changed.
80 If there are any date based controls , display the error
81 message
82 PO_PO_NFC_DATE_CONTROLS_EXIST. This returns failure.
83
84 PARAMETERS:
85
86 RETURN VALUE:
87
88 DESIGN REFERENCES: ../POXPOMPO.doc
89
90 ALGORITHM:
91
92 NOTES:
93
94 OPEN ISSUES:
95
96 CLOSED ISSUES:
97
98 CHANGE HISTORY:
99 ===========================================================================*/
100
101 FUNCTION val_date_notif(X_po_header_id number,
102 X_end_date date)
103 return boolean;
104
105 END PO_NOTIF_CONTROLS_SV;