1 PACKAGE igs_as_documents_api AUTHID CURRENT_USER AS
2 /* $Header: IGSAS42S.pls 115.2 2002/11/28 22:49:53 nsidana noship $ */
3
4 /*******************************************************************************
5 Created by : rbezawad
6 Date created : 18-Jan-2002
7 Purpose : This procedure updates the order status and the items status of the order.
8
9 Known limitations/enhancements/remarks:
10
11 Change History: (who, when, what: NO CREATION RECORDS HERE!)
12 Who When What
13
14 *******************************************************************************/
15 PROCEDURE update_order_item_status (
16 errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY NUMBER);
18
19
20 /*******************************************************************************
21 Created by : rbezawad
22 Date created : 21-Jan-2002
23 Purpose : This procedure updates Transcipt's Order, Item Statuses to INPROCESS.
24 And also inserts the Transcripts Request record into Interface table.
25
26 Known limitations/enhancements/remarks:
27
28 Change History: (who, when, what: NO CREATION RECORDS HERE!)
29 Who When What
30
31 *******************************************************************************/
32 PROCEDURE update_document_details (
33 p_order_number IN NUMBER,
34 p_item_number IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
36 p_return_status OUT NOCOPY VARCHAR2,
37 p_msg_count OUT NOCOPY NUMBER,
38 p_msg_data OUT NOCOPY VARCHAR2,
39 P_PERSON_ID IN VARCHAR2 DEFAULT NULL,
40 P_FEE_AMT IN NUMBER DEFAULT NULL,
41 P_RECORDED_BY IN NUMBER DEFAULT NULL,
42 P_PLAN_ID IN NUMBER DEFAULT NULL,
43 P_INVOICE_ID IN NUMBER DEFAULT NULL,
44 P_PLAN_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
45 P_PLAN_CI_SEQUENCE_NUMBER IN NUMBER DEFAULT NULL
46
47 );
48
49 procedure upd_doc_fee_pmnt(
50 p_person_id NUMBER,
51 p_plan_id NUMBER,
52 p_num_copies NUMBER,
53 p_program_on_file VARCHAR2,
54 p_operation VARCHAR2
55 ) ;
56
57 END igs_as_documents_api;
[Home] [Help]