[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT s.project_id
FROM ( SELECT project_id , project_number FROM pjm_seiban_numbers
UNION ALL
SELECT project_id , segment1 FROM pa_projects_all ) s
WHERE s.project_number = P_seiban_number;
SELECT s.project_id
FROM ( SELECT project_id , project_name FROM pjm_seiban_numbers
UNION ALL
SELECT project_id , name FROM pa_projects_all ) s
WHERE s.project_name = P_seiban_name;
SELECT meaning
FROM fnd_common_lookups
WHERE application_id = 704
AND lookup_type = 'PLANNING_GROUP'
AND lookup_code = P_planning_group
AND sysdate BETWEEN nvl( start_date_active , sysdate - 1)
AND nvl( end_date_active , sysdate + 1)
AND nvl( enabled_flag , 'N' ) = 'Y';
select organization_id from HR_ORGANIZATION_INFORMATION
where ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND ORG_INFORMATION1 = 'OPERATING_UNIT'
AND ORG_INFORMATION2 = 'Y'
AND organization_id = P_operating_unit;
SELECT pa_projects_s.nextval INTO l_project_id FROM dual;
INSERT INTO pjm_seiban_numbers
( project_id
, project_number
, project_name
, operating_unit
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
) VALUES
( l_project_id
, P_seiban_number
, P_seiban_name
, P_operating_unit
, P_DFF.Category
, P_DFF.Attr1
, P_DFF.Attr2
, P_DFF.Attr3
, P_DFF.Attr4
, P_DFF.Attr5
, P_DFF.Attr6
, P_DFF.Attr7
, P_DFF.Attr8
, P_DFF.Attr9
, P_DFF.Attr10
, P_DFF.Attr11
, P_DFF.Attr12
, P_DFF.Attr13
, P_DFF.Attr14
, P_DFF.Attr15
, sysdate
, login_id
, sysdate
, user_id
, login_id
);
SELECT nvl( P_org_list(i).cost_group_id , default_cost_group_id )
INTO l_cost_group_id
FROM mtl_parameters
WHERE organization_id = P_org_list(i).organization_id;
PJM_PROJECT_PARAM_PUB.update_planning_group
( P_api_version => P_api_version
, P_init_msg_list => FND_API.G_FALSE
, P_commit => FND_API.G_FALSE
, X_return_status => X_return_status
, X_msg_count => X_msg_count
, X_msg_data => X_msg_data
, P_project_id => l_project_id
, P_planning_group => P_planning_group );