APPS.OKI_LOAD_OKV_PVT dependencies on OKI_SALES_K_HDRS

Line 27: -- from oki_sales_k_hdrs table.

23: -- 29-OCT-2003 axraghav Modified l_org_id_csr in OKIROKVB.pls to populate
24: -- null for the orgnization names
25: -- Modified the proceures calc_okv_dtl1,calc_okv_dtl2,
26: -- calc_okv_sum to calculate the base price negotiated
27: -- from oki_sales_k_hdrs table.
28: --------------------------------------------------------------------------------
29:
30: -- Global exception declaration
31:

Line 323: FROM oki_sales_k_hdrs shd

319: CURSOR l_org_id_csr IS
320: SELECT DISTINCT shd.authoring_org_id org_id
321: , /*11510 change*/ NULL organization_name
322: , shd.scs_code
323: FROM oki_sales_k_hdrs shd
324: ;
325:
326: -- Cursor that calculates the days renewals outstanding
327: -- for a particular organization and subclass

Line 335: FROM oki_sales_k_hdrs shd

331: , p_scs_code IN VARCHAR2
332: ) IS
333: SELECT ROUND(NVL(SUM(TRUNC(p_summary_build_date ) - TRUNC(shd.creation_date)), 0)
334: / DECODE(COUNT(shd.chr_id), NULL, 1, 0, 1, COUNT(shd.chr_id)), 2) dro_value
335: FROM oki_sales_k_hdrs shd
336: WHERE shd.ste_code = 'ENTERED'
337: AND shd.is_new_yn IS NULL
338: AND shd.authoring_org_id = p_authoring_org_id
339: AND shd.scs_code = p_scs_code

Line 352: FROM oki_sales_k_hdrs shd

348: , p_authoring_org_id IN NUMBER
349: , p_scs_code IN VARCHAR2
350: ) IS
351: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
352: FROM oki_sales_k_hdrs shd
353: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE')
354: AND shd.win_percent IS NOT NULL
355: AND shd.close_date IS NOT NULL
356: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 374: FROM oki_sales_k_hdrs shd

370: , p_authoring_org_id IN NUMBER
371: , p_scs_code IN VARCHAR2
372: ) IS
373: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
374: FROM oki_sales_k_hdrs shd
375: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE', 'ENTERED')
376: AND shd.win_percent IS NOT NULL
377: AND shd.close_date IS NOT NULL
378: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 399: oki_sales_k_hdrs shd

395: ) IS
396: SELECT /*11510 changes removed NVL(SUM(cle.price_negotiated * odr.conversion_rate), 0) */ SUM(shd.base_contract_amount) base_price_negotiated
397: FROM
398: /* 11510 changes removed okc_k_lines_b cle */
399: oki_sales_k_hdrs shd
400: , okc_operation_lines ole
401: , okc_operation_instances oie
402: , okc_class_operations cop
403: /*,11510 changes removed oki_daily_rates odr */

Line 767: FROM oki_sales_k_hdrs shd

763:
764: -- Cursor to get all the organizations
765: CURSOR l_scs_csr IS
766: SELECT DISTINCT shd.scs_code
767: FROM oki_sales_k_hdrs shd
768: ;
769:
770: -- Cursor that calculates the days renewals outstanding for all
771: -- contracts by subclass

Line 778: FROM oki_sales_k_hdrs shd

774: , p_scs_code IN VARCHAR2
775: ) IS
776: SELECT ROUND(NVL(SUM(TRUNC(p_summary_build_date ) - TRUNC(shd.creation_date)), 0)
777: / DECODE(COUNT(shd.chr_id), NULL, 1, 0, 1, COUNT(shd.chr_id)), 2) dro_value
778: FROM oki_sales_k_hdrs shd
779: WHERE shd.ste_code = 'ENTERED'
780: AND shd.is_new_yn IS NULL
781: AND shd.scs_code = p_scs_code
782: ;

Line 793: FROM oki_sales_k_hdrs shd

789: , p_glpr_end_date IN DATE
790: , p_scs_code IN VARCHAR2
791: ) IS
792: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
793: FROM oki_sales_k_hdrs shd
794: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE')
795: AND shd.win_percent IS NOT NULL
796: AND shd.close_date IS NOT NULL
797: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 813: FROM oki_sales_k_hdrs shd

809: , p_glpr_end_date IN DATE
810: , p_scs_code IN VARCHAR2
811: ) IS
812: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
813: FROM oki_sales_k_hdrs shd
814: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE', 'ENTERED')
815: AND shd.win_percent IS NOT NULL
816: AND shd.close_date IS NOT NULL
817: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 836: oki_sales_k_hdrs shd

832: ) IS
833: SELECT /*11510 changes removed NVL(SUM(cle.price_negotiated * odr.conversion_rate), 0) */ SUM(shd.base_contract_amount) base_price_negotiated
834: /* 11510 changes removed okc_k_lines_b cle */
835: FROM
836: oki_sales_k_hdrs shd
837: , okc_operation_lines ole
838: , okc_operation_instances oie
839: , okc_class_operations cop
840: /*,11510 changes removed oki_daily_rates odr */

Line 1203: FROM oki_sales_k_hdrs shd

1199: ( p_summary_build_date IN DATE
1200: ) IS
1201: SELECT ROUND(NVL(SUM(TRUNC(p_summary_build_date ) - TRUNC(shd.creation_date)), 0)
1202: / DECODE(COUNT(shd.chr_id), NULL, 1, 0, 1, COUNT(shd.chr_id)), 2) dro_value
1203: FROM oki_sales_k_hdrs shd
1204: WHERE shd.ste_code = 'ENTERED'
1205: AND shd.is_new_yn IS NULL
1206: ;
1207: rec_l_dro_csr l_dro_csr%ROWTYPE ;

Line 1217: FROM oki_sales_k_hdrs shd

1213: ( p_glpr_start_date IN DATE
1214: , p_glpr_end_date IN DATE
1215: ) IS
1216: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
1217: FROM oki_sales_k_hdrs shd
1218: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE')
1219: AND shd.win_percent IS NOT NULL
1220: AND shd.close_date IS NOT NULL
1221: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 1235: FROM oki_sales_k_hdrs shd

1231: ( p_glpr_start_date IN DATE
1232: , p_glpr_end_date IN DATE
1233: ) IS
1234: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
1235: FROM oki_sales_k_hdrs shd
1236: WHERE shd.ste_code IN ('SIGNED', 'ACTIVE', 'ENTERED')
1237: AND shd.win_percent IS NOT NULL
1238: AND shd.close_date IS NOT NULL
1239: AND shd.close_date BETWEEN p_glpr_start_date AND p_glpr_end_date

Line 1255: oki_sales_k_hdrs shd

1251: SELECT /*11510 changes removed NVL(SUM(cle.price_negotiated * odr.conversion_rate), 0) */
1252: SUM(shd.base_contract_amount) base_price_negotiated
1253: /* 11510 changes removed okc_k_lines_b cle */
1254: FROM
1255: oki_sales_k_hdrs shd
1256: , okc_operation_lines ole
1257: , okc_operation_instances oie
1258: , okc_class_operations cop
1259: /*11510 changes removed oki_daily_rates odr */