[Home] [Help]
94: -- Cursor to get the next sequence number
95: CURSOR C_GET_PRVW_RQST_ID
96: IS
97: SELECT ams_tcop_prvw_requests_s.nextval
98: FROM DUAL;
99:
100:
101: -- Use Autonomous Transaction to commit the data
102: PRAGMA AUTONOMOUS_TRANSACTION;
572:
573: CURSOR C_GET_NEXT_PRVW_CONTACT
574: IS
575: SELECT AMS_TCOP_PRVW_CONTACTS_S.NEXTVAL
576: FROM DUAL;
577:
578:
579: l_schedule_id_list NUMBER_TABLE;
580: l_contact_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S
1319: CURSOR C_GET_NEXT_FATIGUE
1320: IS
1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
1322: FROM DUAL;
1323:
1324: CURSOR C_GET_NEXT_FTG_DTL
1325: IS
1326: SELECT ams_tcop_prvw_ftg_dtls_s.NEXTVAL
1323:
1324: CURSOR C_GET_NEXT_FTG_DTL
1325: IS
1326: SELECT ams_tcop_prvw_ftg_dtls_s.NEXTVAL
1327: FROM DUAL;
1328:
1329: CURSOR C_GET_NEXT_FTG_BY
1330: IS
1331: SELECT ams_tcop_prvw_ftg_by_s.nextval
1328:
1329: CURSOR C_GET_NEXT_FTG_BY
1330: IS
1331: SELECT ams_tcop_prvw_ftg_by_s.nextval
1332: FROM DUAL;
1333:
1334: l_party_id NUMBER;
1335: l_global_fatigue_start_date Date;
1336: l_channel_fatigue_start_date Date;
2598: p_value => to_char(G_PRVW_REQUEST_ID),
2599: p_parameterlist => l_parameter_list);
2600:
2601:
2602: select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;
2603:
2604: l_event_key := to_char(p_list_header_id) || '_' || l_event_key;
2605:
2606: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',
2715: wf_event.AddParameterToList(p_name => 'GLOBAL_NO_OF_PERIOD',
2716: p_value => to_char(G_GLOBAL_NO_OF_PERIOD),
2717: p_parameterlist => l_parameter_list);
2718:
2719: select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;
2720:
2721: l_event_key := to_char(p_list_header_id) || '_' || l_event_key;
2722:
2723: wf_event.raise( p_event_name => 'oracle.apps.ams.tcop.RefreshPreview',