DBA Data[Home] [Help]

APPS.PSB_WORKSHEET dependencies on PSB_SERVICE_PACKAGES

Line 3704: from PSB_SERVICE_PACKAGES

3700: where set_of_books_id = g_set_of_books_id;
3701:
3702: cursor c_SP is
3703: select service_package_id
3704: from PSB_SERVICE_PACKAGES
3705: where base_service_package = 'Y'
3706: and global_worksheet_id = g_global_worksheet_id;
3707:
3708: cursor c_sp_seq is

Line 3709: select psb_service_packages_s.nextval ServicePackageID

3705: where base_service_package = 'Y'
3706: and global_worksheet_id = g_global_worksheet_id;
3707:
3708: cursor c_sp_seq is
3709: select psb_service_packages_s.nextval ServicePackageID
3710: from dual;
3711:
3712: cursor c_Stage is
3713: select Min(sequence_number) sequence_number

Line 3945: insert into PSB_SERVICE_PACKAGES

3941: l_name := FND_MSG_PUB.Get
3942: (p_encoded => FND_API.G_FALSE);
3943: FND_MSG_PUB.Delete_Msg;
3944:
3945: insert into PSB_SERVICE_PACKAGES
3946: (service_package_id, global_worksheet_id,
3947: base_service_package, name,
3948: short_name, description, priority,
3949: last_update_date, last_updated_by,