DBA Data[Home] [Help]

PACKAGE: APPS.CST_DIAGNOSTICS_PKG

Source


1 PACKAGE cst_diagnostics_pkg AUTHID CURRENT_USER AS
2 /* $Header: CSTDIAGS.pls 120.0.12000000.1 2007/07/11 13:42:22 rrshah noship $ */
3 
4  /*---------------------------------------------------------------------------
5 |  FUNCTION     :   TEMP_PO_TAX
6 |  DESCRIPTION  :   Calculates po tax
7 ----------------------------------------------------------------------------*/
8 FUNCTION TEMP_PO_TAX(i_txn_id in  number) RETURN NUMBER;
9 
10 /*---------------------------------------------------------------------------
11 |  PROCEDURE    :   TEMP_PO_RATE
12 |  DESCRIPTION  :   Calculates po_rate.
13 ----------------------------------------------------------------------------*/
14 
15 FUNCTION TEMP_PO_RATE(i_txn_id in  number) RETURN NUMBER;
16 
17 /*---------------------------------------------------------------------------
18 |  PROCEDURE    :   Check_Orphaned
19 |  DESCRIPTION  :   Checks the orphaned transactions for a WIP flow schedule
20 |                   Completion transaction.
21 ----------------------------------------------------------------------------*/
22 PROCEDURE  Check_Orphaned (
23 TXN_ID         IN NUMBER,
24 L_ORG_ID       IN NUMBER);
25 
26 /*---------------------------------------------------------------------------
27 |  PROCEDURE    :   Get_Stuck_Txn_Info
28 |  DESCRIPTION  :   Checks for the bottle neck transactions for Actual costing
29 |                   Organizations.
30 ----------------------------------------------------------------------------*/
31 PROCEDURE   Get_Stuck_Txn_Info;
32 
33 /*---------------------------------------------------------------------------
34 |  FUNCTION     :   Cost_Cutoff_Date
35 |  DESCRIPTION  :   Checks for the Cost Cut-Off date for the organizations
36 |                   for customers on and above release 11.5.7.
37 ---------------------------------------------------------------------------*/
38 
39 FUNCTION Cost_Cutoff_Date( P_ORG_ID IN NUMBER) RETURN DATE;
40 
41 /*---------------------------------------------------------------------------
42 |  PROCEDURE    :   Check_Transactions_MMT
43 |  DESCRIPTION  :   Spools the transactions of MMT and checks for
44 |                   the reason why costing is stuck for the transactions.
45 ---------------------------------------------------------------------------*/
46 PROCEDURE Check_Transactions_MMT
47 ( ORGANIZATION_ID       NUMBER);
48 
49 END cst_diagnostics_pkg;