APPS.MSC_SRP_RELEASE dependencies on DUAL

Line 611: x_individual_owner NUMBER;

607: x_request_number VARCHAR2(2000);
608: x_interaction_id NUMBER;
609: x_workflow_process_id NUMBER := NULL;--2271;
610: x_msg_index_out NUMBER;
611: x_individual_owner NUMBER;
612: x_group_owner NUMBER;
613: x_individual_type VARCHAR2(30);
614: v_lang VARCHAR2(30);
615: l_customer_id NUMBER;

Line 613: x_individual_type VARCHAR2(30);

609: x_workflow_process_id NUMBER := NULL;--2271;
610: x_msg_index_out NUMBER;
611: x_individual_owner NUMBER;
612: x_group_owner NUMBER;
613: x_individual_type VARCHAR2(30);
614: v_lang VARCHAR2(30);
615: l_customer_id NUMBER;
616: l_address_id NUMBER;
617: l_site_use_id NUMBER;

Line 754: Into v_lang from dual;

750: p_service_request_rec.cp_subcomponent_version_id := NULL;
751: p_service_request_rec.language_id := NULL;
752: Begin
753: select userenv('LANG')
754: Into v_lang from dual;
755:
756: p_service_request_rec.LANGUAGE := v_lang;
757: End;
758: p_service_request_rec.cp_ref_number := NULL;

Line 910: x_individual_owner => x_individual_owner,

906: x_request_id => x_request_id,
907: x_request_number => x_request_number,
908: x_interaction_id => x_interaction_id,
909: x_workflow_process_id => x_workflow_process_id,
910: x_individual_owner => x_individual_owner,
911: x_group_owner => x_group_owner,
912: x_individual_type => x_individual_type);
913:
914: --COMMIT;

Line 912: x_individual_type => x_individual_type);

908: x_interaction_id => x_interaction_id,
909: x_workflow_process_id => x_workflow_process_id,
910: x_individual_owner => x_individual_owner,
911: x_group_owner => x_group_owner,
912: x_individual_type => x_individual_type);
913:
914: --COMMIT;
915: IF (x_return_status <> 'S') THEN
916: LOG_MESSAGE('Number of Error Messages : '||TO_CHAR(x_msg_count));

Line 1078: INTO l_group_id FROM dual;

1074: BEGIN -- CAll to API TO Create a WIP JOb
1075: LOG_MESSAGE('-------------------------------------------------------------------');
1076: l_user_id := fnd_global.user_id();
1077: SELECT wip_job_schedule_interface_s.NEXTVAL
1078: INTO l_group_id FROM dual;
1079:
1080: Select To_Char(WIP_JOB_NUMBER_S.NEXTVAL)
1081: into l_wip_job_name from dual;
1082: --l_group_id

Line 1081: into l_wip_job_name from dual;

1077: SELECT wip_job_schedule_interface_s.NEXTVAL
1078: INTO l_group_id FROM dual;
1079:
1080: Select To_Char(WIP_JOB_NUMBER_S.NEXTVAL)
1081: into l_wip_job_name from dual;
1082: --l_group_id
1083: BEGIN
1084: -- INSERTING WIP JOB
1085: LOG_MESSAGE('Inserting into wip_job_schedule_interface');