APPS.PMI_SALES_PKG dependencies on SY_ORGN_MST

Line 26: Pv_pmisa_tp_Sales_orgn sy_orgn_mst.orgn_code%TYPE;

22: and populates a PL/SQL Table
23: ################################################################################# */
24: /*Package Variable for Top N Products */
25:
26: Pv_pmisa_tp_Sales_orgn sy_orgn_mst.orgn_code%TYPE;
27: pv_pmisa_tp_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
28: Pv_pmisa_tp_Prd_start_dt DATE;
29: Pv_pmisa_tp_Prd_end_dt DATE;
30: Pv_pmisa_tp_top_n number;

Line 34: Pv_pmisa_tp_cust_Sales_orgn sy_orgn_mst.orgn_code%TYPE;

30: Pv_pmisa_tp_top_n number;
31:
32: /*Package Variable for Top N customers */
33:
34: Pv_pmisa_tp_cust_Sales_orgn sy_orgn_mst.orgn_code%TYPE;
35: pv_pmisa_tp_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
36: Pv_pmisa_tp_cust_Prd_start_dt DATE;
37: Pv_pmisa_tp_cust_Prd_end_dt DATE;
38: Pv_pmisa_tp_cust_top_n number;

Line 73: FUNCTION PMISA_GET_TOP_N(P_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,

69: /* Package Table to hold Top n Items by OU */
70: pv_pmisa_top_n_item_by_ou pv_pmisa_top_n_item_type;
71:
72:
73: FUNCTION PMISA_GET_TOP_N(P_Sales_orgn IN sy_orgn_mst.orgn_code%TYPE,
74: P_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
75: P_Prd_start_date IN DATE,
76: P_Prd_end_date IN DATE,
77: P_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,

Line 119: pv_pmisa_vd_company sy_orgn_mst.co_code%TYPE;

115: Pv_pmisa_vd_from_period pmi_gl_calendar_v.period_name%TYPE;
116: Pv_pmisa_vd_to_period pmi_gl_calendar_v.period_name%TYPE;
117: pv_pmisa_vd_start_date DATE;
118: pv_pmisa_vd_end_date DATE;
119: pv_pmisa_vd_company sy_orgn_mst.co_code%TYPE;
120:
121: FUNCTION PMISA_VALIDATE_DATE(p_Sales_company IN sy_orgn_mst.co_code%TYPE,
122: p_From_year IN number,
123: p_To_year IN number,

Line 121: FUNCTION PMISA_VALIDATE_DATE(p_Sales_company IN sy_orgn_mst.co_code%TYPE,

117: pv_pmisa_vd_start_date DATE;
118: pv_pmisa_vd_end_date DATE;
119: pv_pmisa_vd_company sy_orgn_mst.co_code%TYPE;
120:
121: FUNCTION PMISA_VALIDATE_DATE(p_Sales_company IN sy_orgn_mst.co_code%TYPE,
122: p_From_year IN number,
123: p_To_year IN number,
124: p_From_period IN pmi_gl_calendar_v.period_name%TYPE,
125: p_To_period IN pmi_gl_calendar_v.period_name%TYPE,