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.

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 754: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;

750: l_order_rec l_order_csr%ROWTYPE;
751: l_ref_order_rec l_order_csr%ROWTYPE;
752: l_cp_tbl cp_tbl_type;
753: l_cp_ctr NUMBER := 0;
754: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
755: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
756: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
757: l_chrid NUMBER := NULL;
758: l_lineid NUMBER := NULL;

Line 755: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;

751: l_ref_order_rec l_order_csr%ROWTYPE;
752: l_cp_tbl cp_tbl_type;
753: l_cp_ctr NUMBER := 0;
754: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
755: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
756: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
757: l_chrid NUMBER := NULL;
758: l_lineid NUMBER := NULL;
759: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;

Line 756: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

752: l_cp_tbl cp_tbl_type;
753: l_cp_ctr NUMBER := 0;
754: l_hdr_rec oks_extwarprgm_pvt.k_header_rec_type;
755: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
756: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
757: l_chrid NUMBER := NULL;
758: l_lineid NUMBER := NULL;
759: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
760: l_renewal_rec oks_extwar_util_pvt.renewal_rec_type;

Line 761: l_contact_tbl oks_extwarprgm_pvt.contact_tbl;

757: l_chrid NUMBER := NULL;
758: l_lineid NUMBER := NULL;
759: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
760: l_renewal_rec oks_extwar_util_pvt.renewal_rec_type;
761: l_contact_tbl oks_extwarprgm_pvt.contact_tbl;
762: l_ptr1 NUMBER := 0;
763: l_covlvl_id NUMBER;
764: l_rule_id NUMBER;
765: l_rule_group_id NUMBER;

Line 1343: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1339:
1340: --mmadhavi end Partial Periods Computation
1341: IF l_hdr_rec.start_date > SYSDATE
1342: THEN
1343: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1344: NULL,
1345: l_ste_code,
1346: l_sts_code
1347: );

Line 1349: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1345: l_ste_code,
1346: l_sts_code
1347: );
1348: ELSE
1349: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1350: NULL,
1351: l_ste_code,
1352: l_sts_code
1353: );

Line 1374: oks_extwarprgm_pvt.create_k_hdr

1370:
1371: /* Added by sjanakir for Bug#7445270 */
1372: l_hdr_rec.ar_interface_yn := 'Y';
1373:
1374: oks_extwarprgm_pvt.create_k_hdr
1375: (p_k_header_rec => l_hdr_rec,
1376: p_contact_tbl => l_contact_tbl,
1377: p_salescredit_tbl_in => l_salescredit_tbl_in,
1378: --mmadhavi bug 4174921

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

1453: || ')'
1454: );
1455: END IF;
1456:
1457: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '|| l_return_status);
1458: fnd_file.put_line
1459: (fnd_file.LOG,
1460: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1461: || l_return_status

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

1456:
1457: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '|| l_return_status);
1458: fnd_file.put_line
1459: (fnd_file.LOG,
1460: '(OKS_EXTWARPRGM_PVT).okc_oc_int_pub.create_k_relationships '
1461: || l_return_status
1462: );
1463:
1464: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

Line 1579: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1575:
1576: --End PPC
1577: IF l_line_rec.srv_sdt > SYSDATE
1578: THEN
1579: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1580: NULL,
1581: l_ste_code,
1582: l_sts_code
1583: );

Line 1585: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1581: l_ste_code,
1582: l_sts_code
1583: );
1584: ELSE
1585: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1586: NULL,
1587: l_ste_code,
1588: l_sts_code
1589: );

Line 1602: oks_extwarprgm_pvt.create_k_service_lines

1598: l_line_rec.exemption_certificate_number := l_k_line_rec.exemption_certificate_number;
1599: l_line_rec.exemption_reason_code := l_k_line_rec.exemption_reason_code;
1600: l_line_rec.tax_status := l_k_line_rec.tax_status;
1601: --
1602: oks_extwarprgm_pvt.create_k_service_lines
1603: (p_k_line_rec => l_line_rec,
1604: p_contact_tbl => l_contact_tbl,
1605: p_salescredit_tbl_in => l_salescredit_tbl_in,
1606: p_caller => 'OC',

Line 1787: oks_extwarprgm_pvt.get_sts_code ('SIGNED',

1783:
1784: --End PPC
1785: IF l_covd_rec.product_start_date > SYSDATE
1786: THEN
1787: oks_extwarprgm_pvt.get_sts_code ('SIGNED',
1788: NULL,
1789: l_ste_code,
1790: l_sts_code
1791: );

Line 1793: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',

1789: l_ste_code,
1790: l_sts_code
1791: );
1792: ELSE
1793: oks_extwarprgm_pvt.get_sts_code ('ACTIVE',
1794: NULL,
1795: l_ste_code,
1796: l_sts_code
1797: );

Line 1801: oks_extwarprgm_pvt.create_k_covered_levels

1797: );
1798: END IF;
1799:
1800: l_covd_rec.product_sts_code := l_sts_code;
1801: oks_extwarprgm_pvt.create_k_covered_levels
1802: (p_k_covd_rec => l_covd_rec,
1803: p_price_attribs => l_pricing_attributes_in,
1804: p_caller => 'OC',
1805: x_order_error => l_order_error,

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

2069: x_timeunit => l_timeunits,
2070: x_return_status => l_return_status
2071: );
2072:
2073: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2074: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2075: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2076: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2077: THEN

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

2070: x_return_status => l_return_status
2071: );
2072:
2073: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2074: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2075: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2076: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2077: THEN
2078: fnd_log.STRING

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

2071: );
2072:
2073: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Get_Duration Status : '|| l_return_status );
2074: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Duration : '|| l_duration );
2075: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Time Unit : '|| l_timeunits );
2076: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2077: THEN
2078: fnd_log.STRING
2079: (fnd_log.level_event,

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

2121: || ')'
2122: );
2123: END IF;
2124:
2125: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_Billing_Schd :: Create_Bill_Sch_Rules Status : '|| l_return_status );
2126: IF l_return_status <> okc_api.g_ret_sts_success
2127: THEN
2128: okc_api.set_message (g_app_name,
2129: g_required_value,

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

2152: || ')'
2153: );
2154: END IF;
2155:
2156: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);
2157: IF NOT l_return_status = 'S'
2158: THEN
2159: RAISE g_exception_halt_validation;
2160: END IF;

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

2220: || ')'
2221: );
2222: END IF;
2223:
2224: --OKS_RENEW_PVT.DEBUG_LOG('(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Update_OM_SLL_Date ' || l_return_status);
2225: IF NOT l_return_status = 'S'
2226: THEN
2227: RAISE g_exception_halt_validation;
2228: END IF;

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

2257: END IF;
2258:
2259: /*
2260: OKS_RENEW_PVT.DEBUG_LOG(TO_CHAR( SYSDATE, 'dd-mon-yyyy HH24:MI:SS')
2261: || '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: Create_Bill_Sch_CP '
2262: || l_return_status
2263: ); */
2264: IF NOT l_return_status = 'S'
2265: THEN

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

2286: || ')'
2287: );
2288: END IF;
2289:
2290: --OKS_RENEW_PVT.DEBUG_LOG( '(OKS_EXTWARPRGM_PVT).Create_contract_Ibnew :: CREATE_BCL_FOR_OM '|| l_return_status);
2291: IF NOT l_return_status = 'S'
2292: THEN
2293: RAISE g_exception_halt_validation;
2294: END IF;