eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OKS_EXTWARPRGM_PVT

Line 652: l_salescredit_tbl_in oks_extwarprgm_pvt.salescredit_tbl;

648: l_k_header_rec oks_extwar_util_pvt.header_rec_type;
649: --Line
650: l_k_line_rec oks_extwar_util_pvt.line_rec_type;
651: --SalesCredit
652: l_salescredit_tbl_in oks_extwarprgm_pvt.salescredit_tbl;
653: --Pricing Attributes
654: l_pricing_attributes_in oks_extwarprgm_pvt.pricing_attributes_type;
655: --For Creating Contract
656: l_extwar_rec oks_extwarprgm_pvt.extwar_rec_type;

Line 654: l_pricing_attributes_in oks_extwarprgm_pvt.pricing_attributes_type;

650: l_k_line_rec oks_extwar_util_pvt.line_rec_type;
651: --SalesCredit
652: l_salescredit_tbl_in oks_extwarprgm_pvt.salescredit_tbl;
653: --Pricing Attributes
654: l_pricing_attributes_in oks_extwarprgm_pvt.pricing_attributes_type;
655: --For Creating Contract
656: l_extwar_rec oks_extwarprgm_pvt.extwar_rec_type;
657: l_cp_id NUMBER;
658: l_cp_name VARCHAR2 (240);

Line 656: l_extwar_rec oks_extwarprgm_pvt.extwar_rec_type;

652: l_salescredit_tbl_in oks_extwarprgm_pvt.salescredit_tbl;
653: --Pricing Attributes
654: l_pricing_attributes_in oks_extwarprgm_pvt.pricing_attributes_type;
655: --For Creating Contract
656: l_extwar_rec oks_extwarprgm_pvt.extwar_rec_type;
657: l_cp_id NUMBER;
658: l_cp_name VARCHAR2 (240);
659: l_cp_desc VARCHAR2 (240);
660: l_cp_qty NUMBER;

Line 768: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;

764: l_order_rec l_order_csr%ROWTYPE;
765: l_ref_order_rec l_order_csr%ROWTYPE;
766: l_cp_tbl cp_tbl_type;
767: l_cp_ctr NUMBER := 0;
768: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
769: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
770: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
771: l_chrid NUMBER := NULL;
772: l_lineid NUMBER := NULL;

Line 769: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;

765: l_ref_order_rec l_order_csr%ROWTYPE;
766: l_cp_tbl cp_tbl_type;
767: l_cp_ctr NUMBER := 0;
768: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
769: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
770: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
771: l_chrid NUMBER := NULL;
772: l_lineid NUMBER := NULL;
773: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;

Line 770: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

766: l_cp_tbl cp_tbl_type;
767: l_cp_ctr NUMBER := 0;
768: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
769: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
770: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
771: l_chrid NUMBER := NULL;
772: l_lineid NUMBER := NULL;
773: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
774: l_renewal_rec oks_extwar_util_pvt.renewal_rec_type;

Line 775: l_contact_tbl oks_extwarprgm_pvt.contact_tbl;

771: l_chrid NUMBER := NULL;
772: l_lineid NUMBER := NULL;
773: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
774: l_renewal_rec oks_extwar_util_pvt.renewal_rec_type;
775: l_contact_tbl oks_extwarprgm_pvt.contact_tbl;
776: l_ptr1 NUMBER := 0;
777: l_covlvl_id NUMBER;
778: l_rule_id NUMBER;
779: l_rule_group_id NUMBER;

Line 1511: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1507:
1508: /*modified for bug 16562247*/
1509: IF l_hdr_rec.start_date > SYSDATE
1510: THEN
1511: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1512: NULL,
1513: l_ste_code,
1514: l_sts_code
1515: );

Line 1517: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1513: l_ste_code,
1514: l_sts_code
1515: );
1516: ELSIF l_hdr_rec.start_date <= SYSDATE AND l_hdr_rec.end_date >= SYSDATE THEN
1517: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1518: NULL,
1519: l_ste_code,
1520: l_sts_code
1521: );

Line 1523: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',

1519: l_ste_code,
1520: l_sts_code
1521: );
1522: ELSIF l_hdr_rec.end_date < SYSDATE THEN
1523: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',
1524: NULL,
1525: l_ste_code,
1526: l_sts_code
1527: );

Line 1548: oks_extwarprgm_pvt.create_k_hdr

1544:
1545: /* Added by sjanakir for Bug#7445270 */
1546: l_hdr_rec.ar_interface_yn := 'Y';
1547:
1548: oks_extwarprgm_pvt.create_k_hdr
1549: (p_k_header_rec => l_hdr_rec,
1550: p_contact_tbl => l_contact_tbl,
1551: p_salescredit_tbl_in => l_salescredit_tbl_in,
1552: --mmadhavi bug 4174921

Line 1631: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '|| l_return_status);

1627: || ')'
1628: );
1629: END IF;
1630:
1631: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '|| l_return_status);
1632: fnd_file.put_line
1633: (fnd_file.LOG,
1634: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1635: || l_return_status

Line 1634: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '

1630:
1631: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '|| l_return_status);
1632: fnd_file.put_line
1633: (fnd_file.LOG,
1634: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1635: || l_return_status
1636: );
1637:
1638: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

Line 1754: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1750: --End PPC
1751: /*modified for bug 16562247*/
1752: IF l_line_rec.srv_sdt > SYSDATE
1753: THEN
1754: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1755: NULL,
1756: l_ste_code,
1757: l_sts_code
1758: );

Line 1760: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1756: l_ste_code,
1757: l_sts_code
1758: );
1759: ELSIF l_line_rec.srv_sdt <= SYSDATE and l_line_rec.srv_edt >= SYSDATE THEN
1760: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1761: NULL,
1762: l_ste_code,
1763: l_sts_code
1764: );

Line 1766: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',

1762: l_ste_code,
1763: l_sts_code
1764: );
1765: ELSIF l_line_rec.srv_edt < SYSDATE THEN
1766: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',
1767: NULL,
1768: l_ste_code,
1769: l_sts_code
1770: );

Line 1789: oks_extwarprgm_pvt.create_k_service_lines

1785: l_line_rec.exemption_certificate_number := l_k_line_rec.exemption_certificate_number;
1786: l_line_rec.exemption_reason_code := l_k_line_rec.exemption_reason_code;
1787: l_line_rec.tax_status := l_k_line_rec.tax_status;
1788: --
1789: oks_extwarprgm_pvt.create_k_service_lines
1790: (p_k_line_rec => l_line_rec,
1791: p_contact_tbl => l_contact_tbl,
1792: p_salescredit_tbl_in => l_salescredit_tbl_in,
1793: p_caller => 'OC',

Line 1991: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1987:
1988: /*modified for bug 16562247*/
1989: IF l_covd_rec.product_start_date > SYSDATE
1990: THEN
1991: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1992: NULL,
1993: l_ste_code,
1994: l_sts_code
1995: );

Line 1997: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1993: l_ste_code,
1994: l_sts_code
1995: );
1996: ELSIF l_covd_rec.product_start_date <= SYSDATE AND l_covd_rec.product_end_date >= SYSDATE THEN
1997: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1998: NULL,
1999: l_ste_code,
2000: l_sts_code
2001: );

Line 2003: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',

1999: l_ste_code,
2000: l_sts_code
2001: );
2002: ELSIF l_covd_rec.product_end_date < SYSDATE THEN
2003: oks_extwarprgm_pvt.get_sts_code ('EXPIRED',
2004: NULL,
2005: l_ste_code,
2006: l_sts_code
2007: );

Line 2011: oks_extwarprgm_pvt.create_k_covered_levels

2007: );
2008: END IF;
2009:
2010: l_covd_rec.product_sts_code := l_sts_code;
2011: oks_extwarprgm_pvt.create_k_covered_levels
2012: (p_k_covd_rec => l_covd_rec,
2013: p_price_attribs => l_pricing_attributes_in,
2014: p_caller => 'OC',
2015: x_order_error => l_order_error,

Line 2699: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );

2695: x_timeunit => l_timeunits,
2696: x_return_status => l_return_status
2697: );
2698:
2699: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2700: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2701: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2702: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2703: THEN

Line 2700: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );

2696: x_return_status => l_return_status
2697: );
2698:
2699: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2700: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2701: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2702: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2703: THEN
2704: fnd_log.STRING

Line 2701: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );

2697: );
2698:
2699: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2700: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2701: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2702: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2703: THEN
2704: fnd_log.STRING
2705: (fnd_log.level_event,

Line 2752: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Create_Bill_Sch_Rules Status : '|| l_return_status );

2748: || ')'
2749: );
2750: END IF;
2751:
2752: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Create_Bill_Sch_Rules Status : '|| l_return_status );
2753: IF l_return_status <> okc_api.g_ret_sts_success
2754: THEN
2755: okc_api.set_message (g_app_name,
2756: g_required_value,

Line 2800: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);

2796: || ')'
2797: );
2798: END IF;
2799:
2800: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);
2801: IF NOT l_return_status = 'S'
2802: THEN
2803: RAISE g_exception_halt_validation;
2804: END IF;

Line 2868: --OKS_RENEW_PVT.DEBUG_LOG('(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Update_OM_SLL_Date ' || l_return_status);

2864: || ')'
2865: );
2866: END IF;
2867:
2868: --OKS_RENEW_PVT.DEBUG_LOG('(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Update_OM_SLL_Date ' || l_return_status);
2869: IF NOT l_return_status = 'S'
2870: THEN
2871: RAISE g_exception_halt_validation;
2872: END IF;

Line 2905: || '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Create_Bill_Sch_CP '

2901: END IF;
2902:
2903: /*
2904: OKS_RENEW_PVT.DEBUG_LOG(TO_CHAR( SYSDATE, 'dd-mon-yyyy HH24:MI:SS')
2905: || '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Create_Bill_Sch_CP '
2906: || l_return_status
2907: ); */
2908: IF NOT l_return_status = 'S'
2909: THEN

Line 2934: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);

2930: || ')'
2931: );
2932: END IF;
2933:
2934: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);
2935: IF NOT l_return_status = 'S'
2936: THEN
2937: RAISE g_exception_halt_validation;
2938: END IF;