PACKAGE: APPS.ARP_MAINTAIN_PS

Source

1 PACKAGE arp_maintain_ps AS
2 /* $Header: ARTEMPSS.pls 120.3.12010000.1 2008/07/24 16:56:24 appldev ship $ */
3 
4 --
5 -- global error buffer
6 --
7 g_error_buffer			VARCHAR2(1000);
8 
9 --
10 -- Public cursors
11 --
12 doc_combo_select_c		INTEGER;
13 doc_update_adj_c		INTEGER;
14 doc_insert_audit_c		INTEGER;
15 
16 --
17 -- Public user-defined exceptions
18 --
19 
20 
21 ----------------------------------------------------------------------------
22 --
23 -- PROCEDURE NAME:  maintain_payment_schedules
24 --
25 -- DECSRIPTION:
26 --   Server-side entry point for the Maintain Payment Schedules.
27 --
28 -- ARGUMENTS:
29 --      IN:
30 --	  mode			(I)nsert, (D)elete or (U)pdate
31 --	  customer_trx_id	Transaction's payment sched to be modified
32 --	  payment_schedule_id	Specific id to be changed.
33 --				For U mode only and regular CM only.
34 --				Must pass value for amount parameters.
35 --	  line_amount		New CM line amount
36 --	  tax_amount		New CM tax amount
37 --	  freight_amount	New CM freight amount
38 --	  charge_amount		New CM charges amount
39 --	  reversed_cash_receipt_id	For DM reversals, I mode only
40 --
41 --      IN/OUT:
42 --	  applied_commitment_amount	Amount of invoice applied to commitment
43 --
44 --      OUT:
45 --
46 -- NOTES:
47 --   Exception raised if Oracle error.
48 --   App_exception is raised for all other fatal errors and a message
49 --   is put on the AOL stack.  The public variable g_error_buffer is
50 --   populated for both types of errors.
51 --
52 --
53 -- HISTORY:
54 --
55 ----------------------------------------------------------------------------
56 PROCEDURE maintain_payment_schedules(
57 	p_mode			IN VARCHAR2,
58 	p_customer_trx_id	IN NUMBER,
59 	p_payment_schedule_id	IN NUMBER,
60 	p_line_amount		IN NUMBER,
61 	p_tax_amount		IN NUMBER,
62 	p_freight_amount	IN NUMBER,
63 	p_charge_amount		IN NUMBER,
64 	p_applied_commitment_amount	IN OUT NOCOPY NUMBER,
65 	p_reversed_cash_receipt_id	IN NUMBER DEFAULT NULL
66 );
67 
68 PROCEDURE test_build_doc_combo_sql;
69 PROCEDURE test_build_doc_update_adj_sql( p_where_clause VARCHAR2 );
70 PROCEDURE test_build_doc_ins_audit_sql( p_where_clause VARCHAR2 );
71 PROCEDURE test_update_adj_doc_number(
72 		p_customer_trx_id 	BINARY_INTEGER,
73 		p_update_where_clause	VARCHAR2 ) ;
74 
75 
76 PROCEDURE init;
77 
78 END arp_maintain_ps;