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.OKE_BILLING_EVENT_PUB dependencies on OKE_BILLING_EVENT_PUB

Line 1: PACKAGE BODY OKE_BILLING_EVENT_PUB AS

1: PACKAGE BODY OKE_BILLING_EVENT_PUB AS
2: /* $Header: OKEPDBLB.pls 120.0.12020000.2 2013/02/22 06:38:25 ansraj noship $ */
3:
4: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
5:

Line 35: Function validate_billing_attributes(p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type )

31: G_EXCEPTION_HALT_VALIDATION exception;
32:
33:
34:
35: Function validate_billing_attributes(p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type )
36: RETURN VARCHAR2 IS
37:
38: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
39: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 43: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

39: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
40:
41:
42: PROCEDURE Validate_Header_ID (X_Return_Status OUT NOCOPY VARCHAR2,
43: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
44:
45: L_Value VARCHAR2(1) := 'N';
46:
47: CURSOR C (P_ID NUMBER) IS

Line 100: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

96:
97: End Validate_Header_ID;
98:
99: PROCEDURE Validate_Line_ID (X_Return_Status OUT NOCOPY VARCHAR2,
100: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
101:
102: L_Value VARCHAR2(1) := 'N';
103:
104: CURSOR C (P_ID NUMBER) IS

Line 184: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

180:
181:
182:
183: PROCEDURE Validate_Deliverable_Id(X_Return_Status OUT NOCOPY VARCHAR2,
184: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
185: L_Value VARCHAR2(1) := 'N';
186:
187: CURSOR C (P_LINE_ID NUMBER, P_DEL_ID NUMBER ) IS
188: SELECT 'X'

Line 242: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

238:
239: End Validate_Deliverable_Id;
240:
241: PROCEDURE Validate_Project_ID (X_Return_Status OUT NOCOPY VARCHAR2,
242: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
243:
244: L_Line_Id Number;
245: L_Sequence Number := 1;
246: L_Max_Sequence Number;

Line 378: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

374:
375: End Validate_Project_ID;
376:
377: PROCEDURE Validate_Task_ID (X_Return_Status OUT NOCOPY VARCHAR2,
378: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
379: L_Value VARCHAR2(1) := 'N';
380:
381: CURSOR C (P_ID1 NUMBER, P_ID2 NUMBER) IS
382: SELECT 'X'

Line 449: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

445:
446: End Validate_Task_ID;
447:
448: PROCEDURE Validate_BILL_EVENT_TYPE (X_Return_Status OUT NOCOPY VARCHAR2,
449: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
450: L_Value VARCHAR2(1) := 'N';
451:
452: CURSOR C (p_event_type varchar2) IS
453: SELECT 'X'

Line 508: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

504:
505: End Validate_BILL_EVENT_TYPE;
506:
507: PROCEDURE Validate_item (X_Return_Status OUT NOCOPY VARCHAR2,
508: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
509: L_Value VARCHAR2(1) := 'N';
510:
511: CURSOR C (p_id NUMBER,p_inv_org number) IS
512: SELECT 'X' from mtl_item_flexfields where organization_id= p_inv_org

Line 573: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

569:
570: End Validate_item;
571:
572: PROCEDURE Validate_CHANGE_REQUEST_ID (X_Return_Status OUT NOCOPY VARCHAR2,
573: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
574: L_Value VARCHAR2(1) := 'N';
575:
576: CURSOR C (p_id NUMBER,P_HEADEr_ID NUMBER) IS
577: SELECT 'X' FROM oke_chg_requests_v WHERE k_header_id=P_HEADER_ID

Line 631: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

627:
628: End Validate_CHANGE_REQUEST_ID;
629:
630: PROCEDURE Validate_bill_org (X_Return_Status OUT NOCOPY VARCHAR2,
631: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
632: L_Value VARCHAR2(1) := 'N';
633:
634: CURSOR C (p_id NUMBER,p_bill_ou number) IS
635: SELECT 'X' from pa_all_organizations paorg,hr_organization_units hrorg

Line 701: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

697:
698: End Validate_bill_org;
699:
700: PROCEDURE Validate_bill_fund_ref (X_Return_Status OUT NOCOPY VARCHAR2,
701: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
702: L_Value VARCHAR2(1) := 'N';
703:
704: CURSOR C IS
705: select 'X'

Line 765: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS

761:
762: End Validate_bill_fund_ref;
763:
764: PROCEDURE Validate_currency (X_Return_Status OUT NOCOPY VARCHAR2,
765: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
766: L_Value VARCHAR2(1) := 'N';
767:
768:
769:

Line 1171: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,

1167: END Recalculate_price;
1168:
1169: PROCEDURE create_k_billing_event(p_api_version IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1171: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1172: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1173: x_return_status OUT NOCOPY VARCHAR2,
1174: x_msg_count OUT NOCOPY NUMBER,
1175: x_msg_data OUT NOCOPY VARCHAR2

Line 1172: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,

1168:
1169: PROCEDURE create_k_billing_event(p_api_version IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1171: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1172: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1173: x_return_status OUT NOCOPY VARCHAR2,
1174: x_msg_count OUT NOCOPY NUMBER,
1175: x_msg_data OUT NOCOPY VARCHAR2
1176: )

Line 1182: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;

1178: l_event_id NUMBER;
1179: l_api_name CONSTANT VARCHAR2(30) := 'create_k_billing_event';
1180: l_api_version CONSTANT NUMBER := 1.0;
1181: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1182: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;
1183: l_bill_unit_price NUMBER;
1184: l_REVENUE_AMOUNT NUMBER;
1185: l_exchange_rate NUMBER;
1186:

Line 1644: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,

1640: ----------------------------------
1641: -- FUNCTION populate_new_record --
1642: ----------------------------------
1643: FUNCTION populate_new_record (
1644: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1645: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type
1646: ) RETURN VARCHAR2 IS
1647:
1648:

Line 1645: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type

1641: -- FUNCTION populate_new_record --
1642: ----------------------------------
1643: FUNCTION populate_new_record (
1644: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
1645: x_k_billing_event_rec OUT NOCOPY OKE_BILLING_EVENT_PUB.k_billing_event_rec_type
1646: ) RETURN VARCHAR2 IS
1647:
1648:
1649: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1705: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;

1701: from oke_k_billing_events
1702: where Billing_Event_Id = p_k_billing_event_rec.billing_event_id;
1703: l_bill_currency VARCHAR2(40);
1704:
1705: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;
1706: l_no_data_found boolean:= TRUE;
1707:
1708: BEGIN
1709:

Line 2022: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,

2018:
2019:
2020: PROCEDURE update_k_billing_event(p_api_version IN NUMBER,
2021: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2022: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type,
2023: x_return_status OUT NOCOPY VARCHAR2,
2024: x_msg_count OUT NOCOPY NUMBER,
2025: x_msg_data OUT NOCOPY VARCHAR2
2026: )

Line 2033: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;

2029: l_event_id NUMBER;
2030: l_api_name CONSTANT VARCHAR2(30) := 'update_k_billing_event';
2031: l_api_version CONSTANT NUMBER := 1.0;
2032: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2033: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;
2034: l_bill_unit_price NUMBER;
2035: l_REVENUE_AMOUNT NUMBER;
2036: l_exchange_rate NUMBER;
2037: BEGIN

Line 2287: END OKE_BILLING_EVENT_PUB;

2283: p_api_type => g_api_type);
2284: END delete_k_billing_event;
2285:
2286:
2287: END OKE_BILLING_EVENT_PUB;