[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,
614: -- then termination related fields are not copied.
615: -- In Parameters: p_new_chr_id the contract id
616: -- p_new_cle_id new line id passed
617: -- p_cle_id old line id passed
618: -- Out Parameters: x_return_status standard return status
619: -----------------------------------------------------------------------------
620:
621: Procedure copy_lines_attr
622: (p_cle_id IN NUMBER,
864: -- Procedure: Update_hdr_amount
865: -- Purpose: This procedure updates the header amount
866: -- used to pass to OC APIs
867: -- In Parameters: p_chr_id the contract id
868: -- Out Parameters: x_return_status standard return status
869: -----------------------------------------------------------------------------
870:
871: Procedure Update_Hdr_Amount
872: (
970: -- Purpose: This procedure copies the header billing schedule from
971: -- old contract to new contract
972: -- In Parameters: p_chr_id the contract id
973: -- p_new_chr_id new contract id
974: -- Out Parameters: x_return_status standard return status
975: -----------------------------------------------------------------------------
976:
977: Procedure Copy_Hdr_Bill_Sch( p_chr_id IN Number,
978: p_new_chr_id IN NUMBER,
1120: -- old contract to new contract
1121: -- In Parameters: p_cle_id the line id
1122: -- p_new_cle_id new line id
1123: -- p_new_chr_id new contract id
1124: -- Out Parameters: x_return_status standard return status
1125: -----------------------------------------------------------------------------
1126:
1127: Procedure copy_revenue_distb
1128: (p_cle_id IN NUMBER,
1234: -- Purpose: This procedure copies the header salescredit details
1235: -- from old contract to new contract
1236: -- In Parameters: p_chr_id the contract id
1237: -- p_new_chr_id new contract id
1238: -- Out Parameters: x_return_status standard return status
1239: -----------------------------------------------------------------------------
1240:
1241: Procedure copy_hdr_sales_credits
1242: (p_chr_id IN NUMBER,
1331: --
1332: -- In Parameters: p_cle_id the line id
1333: -- p_new_cle_id new line id
1334: -- p_new_chr_id new contract id
1335: -- Out Parameters: x_return_status standard return status
1336: -----------------------------------------------------------------------------
1337:
1338: Procedure copy_line_sales_credits
1339: (p_cle_id IN NUMBER,
1640: -- In Parameters: p_chr_id the contract id
1641: -- p_cle_id line_id
1642: --Out Parameters x_billing_schedule_type billing_sch_type
1643: -- x_inv_rule_id Invoice Rule id
1644: -- Out Parameters: x_return_status standard return status
1645: -----------------------------------------------------------------------------
1646:
1647: PROCEDURE get_billing_attr
1648: (p_chr_id IN NUMBER,
1729: -- used to pass to OC APIs
1730: -- In Parameters: p_chr_id the contract id
1731: -- p_cle_id line id
1732: -- x_strlvl_tbl stream levels
1733: -- Out Parameters: x_return_status standard return status
1734: -----------------------------------------------------------------------------
1735:
1736: PROCEDURE get_strlvls
1737: (p_chr_id IN NUMBER,
1921: -- made from renew or copy
1922: -- In Parameters: p_billing_schedule_type line billing schedule type
1923: -- In Parameters: p_duration_match flag to check copied/renewed
1924: -- contract duration
1925: -- Out Parameters: x_return_status standard return status
1926: -----------------------------------------------------------------------------
1927:
1928: PROCEDURE sub_copy
1929: (
2129: -- Procedure: chk_Sll_Exists
2130: -- Purpose: This function call checks if Stream Levels exist for
2131: -- the line id passed or not
2132: -- In Parameters: p_cle_id the line id
2133: -- Out Parameters: x_return_status standard return status
2134: -----------------------------------------------------------------------------
2135:
2136: FUNCTION chk_Sll_Exists(p_cle_id IN NUMBER) return number IS
2137:
2162: -- Function : chk_topline_Exists
2163: -- Purpose: This function checks if the topline already exist in
2164: -- oks table to avoid the duplicacy
2165: -- In Parameters: p_cle_id the line id
2166: -- Out Parameters: x_return_status standard return status
2167: -----------------------------------------------------------------------------
2168:
2169: FUNCTION chk_topline_Exists(p_cle_id IN NUMBER) return number IS
2170:
2192: -- Procedure: chk_hdr_effectivity
2193: -- Purpose: This procedure checks the effectivity dates of old
2194: -- contract and the new copied contract
2195: -- In Parameters: p_new_chr_id new contract id
2196: -- Out Parameters: x_return_status standard return status
2197: -- x_flag yes no flag
2198: -----------------------------------------------------------------------------
2199:
2200: PROCEDURE chk_hdr_effectivity
2532: -- In Parameters: p_chr_id contract id
2533: -- p_cle_id ine id
2534: -- p_upd_line_flag upd_line_flag
2535: -- p_bill_profile_flag the line id
2536: -- Out Parameters: x_return_status standard return status
2537: -----------------------------------------------------------------------------
2538:
2539:
2540: Procedure Okscopy
3562: -- Purpose: This procedure updates the line numbers for the subline
3563: -- copied
3564: -- In Parameters: p_chr_id contract id
3565: -- In Parameters: p_cle_id line id
3566: -- Out Parameters: x_return_status standard return status
3567: -----------------------------------------------------------------------------
3568:
3569:
3570: /** Update_line_number procedure overloaded
3624: -- Purpose: This procedure updates the line_numbers of the contract
3625: -- id passed
3626: -- In Parameters: p_chr_id new contract id
3627: -- p_update_top_line flag that is asking us to update line number
3628: -- Out Parameters: x_return_status standard return status
3629: -----------------------------------------------------------------------------
3630:
3631: PROCEDURE Update_Line_Numbers
3632: (
3742: -- Procedure: get_qto_details
3743: -- Purpose: Build several records/tables that hold information to be
3744: -- used to pass to OC APIs
3745: -- In Parameters: p_new_chr_id new contract id
3746: -- Out Parameters: x_return_status standard return status
3747: -- x_flag yes no flag
3748: -----------------------------------------------------------------------------
3749:
3750:
4136: -- Purpose: This procedure takes the okc line id and deletes all
4137: -- lines related to this line in oks_k_lines_b.
4138: --
4139: -- In Parameters: p_cle_id contract line id
4140: -- Out Parameters: x_return_status standard return status
4141: -----------------------------------------------------------------------------
4142: PROCEDURE Delete_OKS_Line(
4143: p_cle_id IN NUMBER,
4144: x_return_status OUT NOCOPY VARCHAR2
4882: 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);
4883: END IF;
4884: END IF;
4885:
4886: --standard api initilization and checks
4887: SAVEPOINT delete_top_sub_line_PUB;
4888: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
5287: RAISE FND_API.g_exc_error;
5288: END IF;
5289:
5290:
5291: --standard check of p_commit
5292: IF FND_API.to_boolean( p_commit ) THEN
5293: COMMIT;
5294: END IF;
5295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN