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 756: Into v_lang from dual;

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

Line 912: x_individual_owner => x_individual_owner,

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

Line 914: x_individual_type => x_individual_type);

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

Line 1081: INTO l_group_id FROM dual;

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

Line 1084: into l_wip_job_name from dual;

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