APPS.OKE_DELIVERABLE_BILLING_PVT dependencies on OKE_K_BILLING_EVENTS

Line 41: FROM oke_k_deliverables_b d, oke_k_billing_events b

37: , b.bill_fund_ref2
38: , b.bill_fund_ref3
39: , b.bill_bill_of_lading
40: , b.bill_serial_num
41: FROM oke_k_deliverables_b d, oke_k_billing_events b
42: WHERE b.billing_event_id = C_Event_ID
43: AND d.deliverable_id = b.deliverable_id;
44:
45: --

Line 692: UPDATE oke_k_billing_events

688: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Updating deliverable with event info ...');
690: END IF;
691:
692: UPDATE oke_k_billing_events
693: SET initiated_flag = 'Y'
694: WHERE billing_event_id = P_Event_ID;
695:
696:

Line 782: UPDATE oke_k_billing_events

778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
779: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Updating deliverable with event info ...');
780: END IF;
781:
782: UPDATE oke_k_billing_events
783: SET pa_event_id = L_Event_ID
784: ,initiated_flag = 'Y'
785: WHERE billing_event_id = P_Event_ID;
786:

Line 1299: UPDATE oke_k_billing_events

1295: ELSIF ( X_return_status = FND_API.G_RET_STS_ERROR ) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299: UPDATE oke_k_billing_events
1300: SET pa_event_id = L_Event_ID
1301: WHERE billing_event_id = P_Event_ID;
1302:
1303: ELSE

Line 1475: Insert Into oke_k_billing_events

1471: ) Is
1472:
1473: Begin
1474:
1475: Insert Into oke_k_billing_events
1476: ( BILLING_EVENT_ID
1477: , PA_EVENT_ID
1478: , K_HEADER_ID
1479: , K_LINE_ID

Line 1586: UPDATE oke_k_billing_events

1582: , P_LAST_UPDATE_DATE IN DATE
1583: ) IS
1584: BEGIN
1585:
1586: UPDATE oke_k_billing_events
1587: SET bill_event_type = P_Bill_Event_Type
1588: , bill_event_date = P_Bill_Event_Date
1589: /* , billing_event_id =
1590: DECODE( SIGN( nvl(billing_event_id,0) - P_Billing_Event_ID )

Line 1652: FROM oke_k_billing_events

1648: BEGIN
1649:
1650: SELECT pa_event_id, ROWID
1651: INTO l_pa_event_id, L_oke_RowID
1652: FROM oke_k_billing_events
1653: WHERE billing_event_id = P_Billing_Event_ID;
1654:
1655: IF l_pa_event_id IS NOT NULL THEN
1656:

Line 1679: DELETE FROM oke_k_billing_events

1675: END IF;
1676: END IF;
1677: END IF;
1678:
1679: DELETE FROM oke_k_billing_events
1680: WHERE ROWID = L_oke_RowID;
1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN

Line 1745: FROM oke_k_billing_events

1741: , bill_serial_num
1742: , bill_fund_ref1
1743: , bill_fund_ref2
1744: , bill_fund_ref3
1745: FROM oke_k_billing_events
1746: WHERE billing_event_id = P_Billing_Event_ID
1747: FOR UPDATE OF Billing_Event_ID NOWAIT;
1748:
1749: RecInfo c%rowtype;