[Home] [Help]
61: -- Procedure: check_ccr_rule
62: -- Purpose: this procedure updates the bank account id and auth
63: -- code
64: -- In Parameters: p_chr_id the contract id
65: -- Out Parameters: x_return_status standard return status
66: -----------------------------------------------------------------------------
67: Procedure check_CCR_rule
68: (p_chr_id IN Number,
69: x_return_status OUT NOCOPY Varchar2)
155: -- Purpose: this procedure updates the bank account id and auth
156: -- code
157: -- In Parameters: p_chr_id the contract id
158: -- In Parameters: p_cle_id the lineid
159: -- Out Parameters: x_return_status standard return status
160: -----------------------------------------------------------------------------
161: Procedure check_CCR_rule_line
162: (p_chr_id IN Number,
163: p_cle_id IN Number,
279: -- Procedure: copy_hdr_attr
280: -- Purpose: This procedure copies header attributes from the old cont-- ract and creates a row in the OKS_K_HEADERS_B table
281: -- In Parameters: p_chr_id the contract id
282: -- p_new_chr_id new contract id
283: -- Out Parameters: x_return_status standard return status
284: -----------------------------------------------------------------------------
285:
286: Procedure copy_hdr_attr
287: (p_chr_id IN NUMBER,
609: -- then termination related fields are not copied.
610: -- In Parameters: p_new_chr_id the contract id
611: -- p_new_cle_id new line id passed
612: -- p_cle_id old line id passed
613: -- Out Parameters: x_return_status standard return status
614: -----------------------------------------------------------------------------
615:
616: Procedure copy_lines_attr
617: (p_cle_id IN NUMBER,
858: -- Procedure: Update_hdr_amount
859: -- Purpose: This procedure updates the header amount
860: -- used to pass to OC APIs
861: -- In Parameters: p_chr_id the contract id
862: -- Out Parameters: x_return_status standard return status
863: -----------------------------------------------------------------------------
864:
865: Procedure Update_Hdr_Amount
866: (
964: -- Purpose: This procedure copies the header billing schedule from
965: -- old contract to new contract
966: -- In Parameters: p_chr_id the contract id
967: -- p_new_chr_id new contract id
968: -- Out Parameters: x_return_status standard return status
969: -----------------------------------------------------------------------------
970:
971: Procedure Copy_Hdr_Bill_Sch( p_chr_id IN Number,
972: p_new_chr_id IN NUMBER,
1112: -- old contract to new contract
1113: -- In Parameters: p_cle_id the line id
1114: -- p_new_cle_id new line id
1115: -- p_new_chr_id new contract id
1116: -- Out Parameters: x_return_status standard return status
1117: -----------------------------------------------------------------------------
1118:
1119: Procedure copy_revenue_distb
1120: (p_cle_id IN NUMBER,
1226: -- Purpose: This procedure copies the header salescredit details
1227: -- from old contract to new contract
1228: -- In Parameters: p_chr_id the contract id
1229: -- p_new_chr_id new contract id
1230: -- Out Parameters: x_return_status standard return status
1231: -----------------------------------------------------------------------------
1232:
1233: Procedure copy_hdr_sales_credits
1234: (p_chr_id IN NUMBER,
1323: --
1324: -- In Parameters: p_cle_id the line id
1325: -- p_new_cle_id new line id
1326: -- p_new_chr_id new contract id
1327: -- Out Parameters: x_return_status standard return status
1328: -----------------------------------------------------------------------------
1329:
1330: Procedure copy_line_sales_credits
1331: (p_cle_id IN NUMBER,
1632: -- In Parameters: p_chr_id the contract id
1633: -- p_cle_id line_id
1634: --Out Parameters x_billing_schedule_type billing_sch_type
1635: -- x_inv_rule_id Invoice Rule id
1636: -- Out Parameters: x_return_status standard return status
1637: -----------------------------------------------------------------------------
1638:
1639: PROCEDURE get_billing_attr
1640: (p_chr_id IN NUMBER,
1721: -- used to pass to OC APIs
1722: -- In Parameters: p_chr_id the contract id
1723: -- p_cle_id line id
1724: -- x_strlvl_tbl stream levels
1725: -- Out Parameters: x_return_status standard return status
1726: -----------------------------------------------------------------------------
1727:
1728: PROCEDURE get_strlvls
1729: (p_chr_id IN NUMBER,
1912: -- made from renew or copy
1913: -- In Parameters: p_billing_schedule_type line billing schedule type
1914: -- In Parameters: p_duration_match flag to check copied/renewed
1915: -- contract duration
1916: -- Out Parameters: x_return_status standard return status
1917: -----------------------------------------------------------------------------
1918:
1919: PROCEDURE sub_copy
1920: (
2120: -- Procedure: chk_Sll_Exists
2121: -- Purpose: This function call checks if Stream Levels exist for
2122: -- the line id passed or not
2123: -- In Parameters: p_cle_id the line id
2124: -- Out Parameters: x_return_status standard return status
2125: -----------------------------------------------------------------------------
2126:
2127: FUNCTION chk_Sll_Exists(p_cle_id IN NUMBER) return number IS
2128:
2153: -- Function : chk_topline_Exists
2154: -- Purpose: This function checks if the topline already exist in
2155: -- oks table to avoid the duplicacy
2156: -- In Parameters: p_cle_id the line id
2157: -- Out Parameters: x_return_status standard return status
2158: -----------------------------------------------------------------------------
2159:
2160: FUNCTION chk_topline_Exists(p_cle_id IN NUMBER) return number IS
2161:
2183: -- Procedure: chk_hdr_effectivity
2184: -- Purpose: This procedure checks the effectivity dates of old
2185: -- contract and the new copied contract
2186: -- In Parameters: p_new_chr_id new contract id
2187: -- Out Parameters: x_return_status standard return status
2188: -- x_flag yes no flag
2189: -----------------------------------------------------------------------------
2190:
2191: PROCEDURE chk_hdr_effectivity
2523: -- In Parameters: p_chr_id contract id
2524: -- p_cle_id ine id
2525: -- p_upd_line_flag upd_line_flag
2526: -- p_bill_profile_flag the line id
2527: -- Out Parameters: x_return_status standard return status
2528: -----------------------------------------------------------------------------
2529:
2530:
2531: Procedure Okscopy
3553: -- Purpose: This procedure updates the line numbers for the subline
3554: -- copied
3555: -- In Parameters: p_chr_id contract id
3556: -- In Parameters: p_cle_id line id
3557: -- Out Parameters: x_return_status standard return status
3558: -----------------------------------------------------------------------------
3559:
3560:
3561: /** Update_line_number procedure overloaded
3615: -- Purpose: This procedure updates the line_numbers of the contract
3616: -- id passed
3617: -- In Parameters: p_chr_id new contract id
3618: -- p_update_top_line flag that is asking us to update line number
3619: -- Out Parameters: x_return_status standard return status
3620: -----------------------------------------------------------------------------
3621:
3622: PROCEDURE Update_Line_Numbers
3623: (
3733: -- Procedure: get_qto_details
3734: -- Purpose: Build several records/tables that hold information to be
3735: -- used to pass to OC APIs
3736: -- In Parameters: p_new_chr_id new contract id
3737: -- Out Parameters: x_return_status standard return status
3738: -- x_flag yes no flag
3739: -----------------------------------------------------------------------------
3740:
3741:
4127: -- Purpose: This procedure takes the okc line id and deletes all
4128: -- lines related to this line in oks_k_lines_b.
4129: --
4130: -- In Parameters: p_cle_id contract line id
4131: -- Out Parameters: x_return_status standard return status
4132: -----------------------------------------------------------------------------
4133: PROCEDURE Delete_OKS_Line(
4134: p_cle_id IN NUMBER,
4135: x_return_status OUT NOCOPY VARCHAR2
4873: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_api_version=' || p_api_version ||' ,p_commit='|| p_commit ||' ,p_line_id='|| p_line_id);
4874: END IF;
4875: END IF;
4876:
4877: --standard api initilization and checks
4878: SAVEPOINT delete_top_sub_line_PUB;
4879: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4881: END IF;
5278: RAISE FND_API.g_exc_error;
5279: END IF;
5280:
5281:
5282: --standard check of p_commit
5283: IF FND_API.to_boolean( p_commit ) THEN
5284: COMMIT;
5285: END IF;
5286: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN