1 PACKAGE igs_as_prod_doc AS
2 /* $Header: IGSAS49S.pls 120.1 2005/09/19 01:34:17 appldev ship $ */
3
4 /*************************************************************
5 Created By :Nalin Kumar
6 Date Created on : 21-Aug-2002
7 Purpose : This process is called by the report producing the documents
8 to check the readiness for production of a document.
9 Know limitations, enhancements or remarks
10 Change History
11 Who When What
12 swaghmar 14-Sep-2005 Bug 4506526, added new functions get_doc_fee and get_del_fee
13 ijeddy 15-feb-2004 Bug 3410409, added a new function get_hold_status
14 (reverse chronological order - newest change first)
15 ***************************************************************/
16 --
17 FUNCTION get_hold_status (
18 p_person_id NUMBER
19 ) RETURN VARCHAR2;
20
21 --
22 PROCEDURE asp_chk_doc_rdns (
23 p_item_number IN NUMBER,
24 p_document_ready OUT NOCOPY VARCHAR2,
25 p_error_mesg OUT NOCOPY VARCHAR2
26 );
27 --
28 PROCEDURE notify_miss_acad_rec_prod (
29 p_person_id IN VARCHAR2,
30 p_order_number IN VARCHAR2,
31 p_item_number IN VARCHAR2,
32 p_document_type IN VARCHAR2,
33 p_recipient_name IN VARCHAR2,
34 p_receiving_inst_name IN VARCHAR2,
35 p_delivery_method IN VARCHAR2,
36 p_fulfillment_date_time IN VARCHAR2
37 );
38 --
39 PROCEDURE wf_launch_as004 (
40 p_user IN VARCHAR2,
41 p_date_produced IN VARCHAR2,
42 p_doc_type IN VARCHAR2
43 ) ;
44 --
45 PROCEDURE wf_set_role (
46 itemtype IN VARCHAR2,
47 itemkey IN VARCHAR2,
48 actid IN NUMBER,
49 funcmode IN VARCHAR2,
50 resultout OUT NOCOPY VARCHAR2
51 );
52 --
53 PROCEDURE asp_update_order_doc (
54 p_item_number IN NUMBER,
55 p_test_mode IN VARCHAR2
56 );
57 --
58 FUNCTION get_doc_fee(
59 p_order_number igs_as_doc_details.order_number%TYPE
60 ) RETURN NUMBER ;
61 --
62 FUNCTION get_del_fee (
63 p_order_number igs_as_doc_details.order_number%TYPE
64 ) RETURN NUMBER;
65 --
66 END igs_as_prod_doc;