[Home] [Help]
979: l_cancel_boolean BOOLEAN;
980: l_auto_create_finance VARCHAR2(40);
981: l_price_basis OTA_EVENTS.price_basis%TYPE;
982: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
983: l_business_group_id_to hr_all_organization_units.organization_id%type;
984: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
985: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
986: l_user NUMBER;
987: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
988: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
989: fapi_result VARCHAR2(40);
990: fapi_from VARCHAR2(5);
991: fapi_to VARCHAR2(5);
992: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
993: l_event_currency_code ota_events.currency_code%type;
994: l_event_status ota_events.event_status%type;
995: l_cost_allocation_keyflex_id VARCHAR2(1000);
996: l_maximum_internal_attendees NUMBER;
1072: evt.course_end_time
1073: FROM OTA_EVENTS_VL evt,
1074: OTA_OFFERINGS ofr,
1075: OTA_CATEGORY_USAGES_TL ctl,
1076: HR_ALL_ORGANIZATION_UNITS hao
1077: WHERE evt.event_id = l_eventid
1078: AND evt.parent_offering_id = ofr.offering_id
1079: AND evt.organization_id = hao.organization_id (+)
1080: AND ctl.Category_usage_id = ofr.delivery_mode_id
2144: CURSOR ORG
2145: IS
2146: SELECT
2147: COST_ALLOCATION_KEYFLEX_ID
2148: FROM HR_ALL_ORGANIZATION_UNITS
2149: WHERE ORGANIZATION_ID = l_organization_id;
2150:
2151: CURSOR SOB(p_set_of_books_id in number)
2152: IS
2155: WHERE SET_OF_BOOKS_ID = p_set_of_books_id;
2156:
2157: CURSOR OFA IS
2158: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2159: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2160: PER_ALL_ASSIGNMENTS_F asg
2161: WHERE hr.organization_id = asg.organization_id and
2162: asg.organization_id = p_organization_id and
2163: asg.assignment_id = p_assignment_id and
2165: asg.effective_end_date;
2166:
2167: CURSOR SPO IS
2168: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2169: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2170: OTA_EVENTS EVT
2171: WHERE hr.organization_id = evt.organization_id and
2172: evt.event_id = p_event_id;
2173:
2219: IF from_rec.HR_COST_SEGMENT is not null THEN
2220: BEGIN
2221:
2222: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2223: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;
2224:
2225:
2226: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2227: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2289: OPEN OFA;
2290: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2291: CLOSE OFA;
2292: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2293: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2294: PER_ALL_ASSIGNMENTS_F asg
2295: WHERE hr.organization_id = asg.organization_id and
2296: asg.organization_id = p_organization_id and
2297: asg.assignment_id = p_assignment_id ; */
2332: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2333: CLOSE SPO;
2334:
2335: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2336: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2337: OTA_EVENTS EVT
2338: WHERE hr.organization_id = evt.organization_id and
2339: evt.event_id = p_event_id; */
2340: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2454: IF to_rec.hr_data_source = 'BGP' THEN
2455: IF to_rec.HR_COST_SEGMENT is not null THEN
2456: BEGIN
2457: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2458: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;
2459:
2460:
2461: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2462: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;