[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
x_LOC_ACC_MAP_ID IN OUT NOCOPY NUMBER,
x_LOC_ACC_MAP_HDR_ID IN NUMBER,
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_creation_date IN DATE,
x_created_by IN NUMBER,
x_last_update_login IN NUMBER,
x_PROPERTY_ID IN NUMBER,
x_LOCATION_ID IN NUMBER,
x_ACCOUNT_LOW IN VARCHAR2,
x_ACCOUNT_HIGH IN VARCHAR2,
x_EXPENSE_TYPE_CODE IN VARCHAR2,
x_EFFECTIVE_FROM_DATE IN DATE,
x_EFFECTIVE_TO_DATE IN DATE,
x_RECOVERABLE_FLAG IN VARCHAR2,
x_SEGMENT1_LOW IN VARCHAR2,
x_SEGMENT1_HIGH IN VARCHAR2,
x_SEGMENT2_LOW IN VARCHAR2,
x_SEGMENT2_HIGH IN VARCHAR2,
x_SEGMENT3_LOW IN VARCHAR2,
x_SEGMENT3_HIGH IN VARCHAR2,
x_SEGMENT4_LOW IN VARCHAR2,
x_SEGMENT4_HIGH IN VARCHAR2,
x_SEGMENT5_LOW IN VARCHAR2,
x_SEGMENT5_HIGH IN VARCHAR2,
x_SEGMENT6_LOW IN VARCHAR2,
x_SEGMENT6_HIGH IN VARCHAR2,
x_SEGMENT7_LOW IN VARCHAR2,
x_SEGMENT7_HIGH IN VARCHAR2,
x_SEGMENT8_LOW IN VARCHAR2,
x_SEGMENT8_HIGH IN VARCHAR2,
x_SEGMENT9_LOW IN VARCHAR2,
x_SEGMENT9_HIGH IN VARCHAR2,
x_SEGMENT10_LOW IN VARCHAR2,
x_SEGMENT10_HIGH IN VARCHAR2,
x_SEGMENT11_LOW IN VARCHAR2,
x_SEGMENT11_HIGH IN VARCHAR2,
x_SEGMENT12_LOW IN VARCHAR2,
x_SEGMENT12_HIGH IN VARCHAR2,
x_SEGMENT13_LOW IN VARCHAR2,
x_SEGMENT13_HIGH IN VARCHAR2,
x_SEGMENT14_LOW IN VARCHAR2,
x_SEGMENT14_HIGH IN VARCHAR2,
x_SEGMENT15_LOW IN VARCHAR2,
x_SEGMENT15_HIGH IN VARCHAR2,
x_SEGMENT16_LOW IN VARCHAR2,
x_SEGMENT16_HIGH IN VARCHAR2,
x_SEGMENT17_LOW IN VARCHAR2,
x_SEGMENT17_HIGH IN VARCHAR2,
x_SEGMENT18_LOW IN VARCHAR2,
x_SEGMENT18_HIGH IN VARCHAR2,
x_SEGMENT19_LOW IN VARCHAR2,
x_SEGMENT19_HIGH IN VARCHAR2,
x_SEGMENT20_LOW IN VARCHAR2,
x_SEGMENT20_HIGH IN VARCHAR2,
x_SEGMENT21_LOW IN VARCHAR2,
x_SEGMENT21_HIGH IN VARCHAR2,
x_SEGMENT22_LOW IN VARCHAR2,
x_SEGMENT22_HIGH IN VARCHAR2,
x_SEGMENT23_LOW IN VARCHAR2,
x_SEGMENT23_HIGH IN VARCHAR2,
x_SEGMENT24_LOW IN VARCHAR2,
x_SEGMENT24_HIGH IN VARCHAR2,
x_SEGMENT25_LOW IN VARCHAR2,
x_SEGMENT25_HIGH IN VARCHAR2,
x_SEGMENT26_LOW IN VARCHAR2,
x_SEGMENT26_HIGH IN VARCHAR2,
x_SEGMENT27_LOW IN VARCHAR2,
x_SEGMENT27_HIGH IN VARCHAR2,
x_SEGMENT28_LOW IN VARCHAR2,
x_SEGMENT28_HIGH IN VARCHAR2,
x_SEGMENT29_LOW IN VARCHAR2,
x_SEGMENT29_HIGH IN VARCHAR2,
x_SEGMENT30_LOW IN VARCHAR2,
x_SEGMENT30_HIGH IN VARCHAR2,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_ORG_ID IN NUMBER default NULL
) IS
CURSOR C IS
SELECT LOC_ACC_MAP_ID
FROM PN_LOC_ACC_MAP_ALL
WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID;
SELECT org_id
FROM pn_loc_acc_map_hdr_all
WHERE loc_acc_map_hdr_id = x_LOC_ACC_MAP_HDR_ID;
INSERT INTO PN_LOC_ACC_MAP_ALL
(LOC_ACC_MAP_ID,
LOC_ACC_MAP_HDR_ID,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
PROPERTY_ID,
LOCATION_ID,
ACCOUNT_LOW,
ACCOUNT_HIGH,
EXPENSE_TYPE_CODE,
EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE,
RECOVERABLE_FLAG,
SEGMENT1_LOW,
SEGMENT1_HIGH,
SEGMENT2_LOW,
SEGMENT2_HIGH,
SEGMENT3_LOW,
SEGMENT3_HIGH,
SEGMENT4_LOW,
SEGMENT4_HIGH,
SEGMENT5_LOW,
SEGMENT5_HIGH,
SEGMENT6_LOW,
SEGMENT6_HIGH,
SEGMENT7_LOW,
SEGMENT7_HIGH,
SEGMENT8_LOW,
SEGMENT8_HIGH,
SEGMENT9_LOW,
SEGMENT9_HIGH,
SEGMENT10_LOW,
SEGMENT10_HIGH,
SEGMENT11_LOW,
SEGMENT11_HIGH,
SEGMENT12_LOW,
SEGMENT12_HIGH,
SEGMENT13_LOW,
SEGMENT13_HIGH,
SEGMENT14_LOW,
SEGMENT14_HIGH,
SEGMENT15_LOW,
SEGMENT15_HIGH,
SEGMENT16_LOW,
SEGMENT16_HIGH,
SEGMENT17_LOW,
SEGMENT17_HIGH,
SEGMENT18_LOW,
SEGMENT18_HIGH,
SEGMENT19_LOW,
SEGMENT19_HIGH,
SEGMENT20_LOW,
SEGMENT20_HIGH,
SEGMENT21_LOW,
SEGMENT21_HIGH,
SEGMENT22_LOW,
SEGMENT22_HIGH,
SEGMENT23_LOW,
SEGMENT23_HIGH,
SEGMENT24_LOW,
SEGMENT24_HIGH,
SEGMENT25_LOW,
SEGMENT25_HIGH,
SEGMENT26_LOW,
SEGMENT26_HIGH,
SEGMENT27_LOW,
SEGMENT27_HIGH,
SEGMENT28_LOW,
SEGMENT28_HIGH,
SEGMENT29_LOW,
SEGMENT29_HIGH,
SEGMENT30_LOW,
SEGMENT30_HIGH,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
ORG_ID)
VALUES (NVL(x_LOC_ACC_MAP_ID,PN_LOC_ACC_MAP_S.NEXTVAL),
x_LOC_ACC_MAP_HDR_ID,
x_last_update_date,
x_last_updated_by,
x_creation_date,
x_created_by,
x_last_update_login,
x_PROPERTY_ID,
x_LOCATION_ID,
x_ACCOUNT_LOW,
x_ACCOUNT_HIGH,
x_EXPENSE_TYPE_CODE,
x_EFFECTIVE_FROM_DATE,
x_EFFECTIVE_TO_DATE,
x_RECOVERABLE_FLAG,
x_SEGMENT1_LOW,
x_SEGMENT1_HIGH,
x_SEGMENT2_LOW,
x_SEGMENT2_HIGH,
x_SEGMENT3_LOW,
x_SEGMENT3_HIGH,
x_SEGMENT4_LOW,
x_SEGMENT4_HIGH,
x_SEGMENT5_LOW,
x_SEGMENT5_HIGH,
x_SEGMENT6_LOW,
x_SEGMENT6_HIGH,
x_SEGMENT7_LOW,
x_SEGMENT7_HIGH,
x_SEGMENT8_LOW,
x_SEGMENT8_HIGH,
x_SEGMENT9_LOW,
x_SEGMENT9_HIGH,
x_SEGMENT10_LOW,
x_SEGMENT10_HIGH,
x_SEGMENT11_LOW,
x_SEGMENT11_HIGH,
x_SEGMENT12_LOW,
x_SEGMENT12_HIGH,
x_SEGMENT13_LOW,
x_SEGMENT13_HIGH,
x_SEGMENT14_LOW,
x_SEGMENT14_HIGH,
x_SEGMENT15_LOW,
x_SEGMENT15_HIGH,
x_SEGMENT16_LOW,
x_SEGMENT16_HIGH,
x_SEGMENT17_LOW,
x_SEGMENT17_HIGH,
x_SEGMENT18_LOW,
x_SEGMENT18_HIGH,
x_SEGMENT19_LOW,
x_SEGMENT19_HIGH,
x_SEGMENT20_LOW,
x_SEGMENT20_HIGH,
x_SEGMENT21_LOW,
x_SEGMENT21_HIGH,
x_SEGMENT22_LOW,
x_SEGMENT22_HIGH,
x_SEGMENT23_LOW,
x_SEGMENT23_HIGH,
x_SEGMENT24_LOW,
x_SEGMENT24_HIGH,
x_SEGMENT25_LOW,
x_SEGMENT25_HIGH,
x_SEGMENT26_LOW,
x_SEGMENT26_HIGH,
x_SEGMENT27_LOW,
x_SEGMENT27_HIGH,
x_SEGMENT28_LOW,
x_SEGMENT28_HIGH,
x_SEGMENT29_LOW,
x_SEGMENT29_HIGH,
x_SEGMENT30_LOW,
x_SEGMENT30_HIGH,
x_attribute_category,
x_attribute1,
x_attribute2,
x_attribute3,
x_attribute4,
x_attribute5,
x_attribute6,
x_attribute7,
x_attribute8,
x_attribute9,
x_attribute10,
x_attribute11,
x_attribute12,
x_attribute13,
x_attribute14,
x_attribute15,
l_org_id
)
RETURNING LOC_ACC_MAP_ID INTO x_LOC_ACC_MAP_ID;
END insert_row;
PROCEDURE update_row (
x_LOC_ACC_MAP_ID IN NUMBER,
x_LOC_ACC_MAP_HDR_ID IN NUMBER,
x_last_update_date IN DATE,
x_last_updated_by IN NUMBER,
x_last_update_login IN NUMBER,
x_PROPERTY_ID IN NUMBER,
x_LOCATION_ID IN NUMBER,
x_ACCOUNT_LOW IN VARCHAR2,
x_ACCOUNT_HIGH IN VARCHAR2,
x_EXPENSE_TYPE_CODE IN VARCHAR2,
x_EFFECTIVE_FROM_DATE IN DATE,
x_EFFECTIVE_TO_DATE IN DATE,
x_RECOVERABLE_FLAG IN VARCHAR2,
x_SEGMENT1_LOW IN VARCHAR2,
x_SEGMENT1_HIGH IN VARCHAR2,
x_SEGMENT2_LOW IN VARCHAR2,
x_SEGMENT2_HIGH IN VARCHAR2,
x_SEGMENT3_LOW IN VARCHAR2,
x_SEGMENT3_HIGH IN VARCHAR2,
x_SEGMENT4_LOW IN VARCHAR2,
x_SEGMENT4_HIGH IN VARCHAR2,
x_SEGMENT5_LOW IN VARCHAR2,
x_SEGMENT5_HIGH IN VARCHAR2,
x_SEGMENT6_LOW IN VARCHAR2,
x_SEGMENT6_HIGH IN VARCHAR2,
x_SEGMENT7_LOW IN VARCHAR2,
x_SEGMENT7_HIGH IN VARCHAR2,
x_SEGMENT8_LOW IN VARCHAR2,
x_SEGMENT8_HIGH IN VARCHAR2,
x_SEGMENT9_LOW IN VARCHAR2,
x_SEGMENT9_HIGH IN VARCHAR2,
x_SEGMENT10_LOW IN VARCHAR2,
x_SEGMENT10_HIGH IN VARCHAR2,
x_SEGMENT11_LOW IN VARCHAR2,
x_SEGMENT11_HIGH IN VARCHAR2,
x_SEGMENT12_LOW IN VARCHAR2,
x_SEGMENT12_HIGH IN VARCHAR2,
x_SEGMENT13_LOW IN VARCHAR2,
x_SEGMENT13_HIGH IN VARCHAR2,
x_SEGMENT14_LOW IN VARCHAR2,
x_SEGMENT14_HIGH IN VARCHAR2,
x_SEGMENT15_LOW IN VARCHAR2,
x_SEGMENT15_HIGH IN VARCHAR2,
x_SEGMENT16_LOW IN VARCHAR2,
x_SEGMENT16_HIGH IN VARCHAR2,
x_SEGMENT17_LOW IN VARCHAR2,
x_SEGMENT17_HIGH IN VARCHAR2,
x_SEGMENT18_LOW IN VARCHAR2,
x_SEGMENT18_HIGH IN VARCHAR2,
x_SEGMENT19_LOW IN VARCHAR2,
x_SEGMENT19_HIGH IN VARCHAR2,
x_SEGMENT20_LOW IN VARCHAR2,
x_SEGMENT20_HIGH IN VARCHAR2,
x_SEGMENT21_LOW IN VARCHAR2,
x_SEGMENT21_HIGH IN VARCHAR2,
x_SEGMENT22_LOW IN VARCHAR2,
x_SEGMENT22_HIGH IN VARCHAR2,
x_SEGMENT23_LOW IN VARCHAR2,
x_SEGMENT23_HIGH IN VARCHAR2,
x_SEGMENT24_LOW IN VARCHAR2,
x_SEGMENT24_HIGH IN VARCHAR2,
x_SEGMENT25_LOW IN VARCHAR2,
x_SEGMENT25_HIGH IN VARCHAR2,
x_SEGMENT26_LOW IN VARCHAR2,
x_SEGMENT26_HIGH IN VARCHAR2,
x_SEGMENT27_LOW IN VARCHAR2,
x_SEGMENT27_HIGH IN VARCHAR2,
x_SEGMENT28_LOW IN VARCHAR2,
x_SEGMENT28_HIGH IN VARCHAR2,
x_SEGMENT29_LOW IN VARCHAR2,
x_SEGMENT29_HIGH IN VARCHAR2,
x_SEGMENT30_LOW IN VARCHAR2,
x_SEGMENT30_HIGH IN VARCHAR2,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2
) IS
BEGIN
UPDATE PN_LOC_ACC_MAP_ALL --sdm_MOAC
SET last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
LOC_ACC_MAP_HDR_ID = x_LOC_ACC_MAP_HDR_ID,
PROPERTY_ID = x_PROPERTY_ID,
LOCATION_ID = x_LOCATION_ID,
ACCOUNT_LOW = x_ACCOUNT_LOW,
ACCOUNT_HIGH = x_ACCOUNT_HIGH,
EXPENSE_TYPE_CODE = x_EXPENSE_TYPE_CODE,
EFFECTIVE_FROM_DATE = x_EFFECTIVE_FROM_DATE,
EFFECTIVE_TO_DATE = x_EFFECTIVE_TO_DATE,
RECOVERABLE_FLAG = x_RECOVERABLE_FLAG,
SEGMENT1_LOW = x_SEGMENT1_LOW,
SEGMENT1_HIGH = x_SEGMENT1_HIGH,
SEGMENT2_LOW = x_SEGMENT2_LOW,
SEGMENT2_HIGH = x_SEGMENT2_HIGH,
SEGMENT3_LOW = x_SEGMENT3_LOW,
SEGMENT3_HIGH = x_SEGMENT3_HIGH,
SEGMENT4_LOW = x_SEGMENT4_LOW,
SEGMENT4_HIGH = x_SEGMENT4_HIGH,
SEGMENT5_LOW = x_SEGMENT5_LOW,
SEGMENT5_HIGH = x_SEGMENT5_HIGH,
SEGMENT6_LOW = x_SEGMENT6_LOW,
SEGMENT6_HIGH = x_SEGMENT6_HIGH,
SEGMENT7_LOW = x_SEGMENT7_LOW,
SEGMENT7_HIGH = x_SEGMENT7_HIGH,
SEGMENT8_LOW = x_SEGMENT8_LOW,
SEGMENT8_HIGH = x_SEGMENT8_HIGH,
SEGMENT9_LOW = x_SEGMENT9_LOW,
SEGMENT9_HIGH = x_SEGMENT9_HIGH,
SEGMENT10_LOW = x_SEGMENT10_LOW,
SEGMENT10_HIGH = x_SEGMENT10_HIGH,
SEGMENT11_LOW = x_SEGMENT11_LOW,
SEGMENT11_HIGH = x_SEGMENT11_HIGH,
SEGMENT12_LOW = x_SEGMENT12_LOW,
SEGMENT12_HIGH = x_SEGMENT12_HIGH,
SEGMENT13_LOW = x_SEGMENT13_LOW,
SEGMENT13_HIGH = x_SEGMENT13_HIGH,
SEGMENT14_LOW = x_SEGMENT14_LOW,
SEGMENT14_HIGH = x_SEGMENT14_HIGH,
SEGMENT15_LOW = x_SEGMENT15_LOW,
SEGMENT15_HIGH = x_SEGMENT15_HIGH,
SEGMENT16_LOW = x_SEGMENT16_LOW,
SEGMENT16_HIGH = x_SEGMENT16_HIGH,
SEGMENT17_LOW = x_SEGMENT17_LOW,
SEGMENT17_HIGH = x_SEGMENT17_HIGH,
SEGMENT18_LOW = x_SEGMENT18_LOW,
SEGMENT18_HIGH = x_SEGMENT18_HIGH,
SEGMENT19_LOW = x_SEGMENT19_LOW,
SEGMENT19_HIGH = x_SEGMENT19_HIGH,
SEGMENT20_LOW = x_SEGMENT20_LOW,
SEGMENT20_HIGH = x_SEGMENT20_HIGH,
SEGMENT21_LOW = x_SEGMENT21_LOW,
SEGMENT21_HIGH = x_SEGMENT21_HIGH,
SEGMENT22_LOW = x_SEGMENT22_LOW,
SEGMENT22_HIGH = x_SEGMENT22_HIGH,
SEGMENT23_LOW = x_SEGMENT23_LOW,
SEGMENT23_HIGH = x_SEGMENT23_HIGH,
SEGMENT24_LOW = x_SEGMENT24_LOW,
SEGMENT24_HIGH = x_SEGMENT24_HIGH,
SEGMENT25_LOW = x_SEGMENT25_LOW,
SEGMENT25_HIGH = x_SEGMENT25_HIGH,
SEGMENT26_LOW = x_SEGMENT26_LOW,
SEGMENT26_HIGH = x_SEGMENT26_HIGH,
SEGMENT27_LOW = x_SEGMENT27_LOW,
SEGMENT27_HIGH = x_SEGMENT27_HIGH,
SEGMENT28_LOW = x_SEGMENT28_LOW,
SEGMENT28_HIGH = x_SEGMENT28_HIGH,
SEGMENT29_LOW = x_SEGMENT29_LOW,
SEGMENT29_HIGH = x_SEGMENT29_HIGH,
SEGMENT30_LOW = x_SEGMENT30_LOW,
SEGMENT30_HIGH = x_SEGMENT30_HIGH,
attribute1 = x_attribute1,
attribute2 = x_attribute2,
attribute3 = x_attribute3,
attribute4 = x_attribute4,
attribute5 = x_attribute5,
attribute6 = x_attribute6,
attribute7 = x_attribute7,
attribute8 = x_attribute8,
attribute9 = x_attribute9,
attribute10 = x_attribute10,
attribute11 = x_attribute11,
attribute12 = x_attribute12,
attribute13 = x_attribute13,
attribute14 = x_attribute14,
attribute15 = x_attribute15
WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID;
END update_row;
SELECT *
FROM PN_LOC_ACC_MAP_ALL
WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID
FOR UPDATE OF LOC_ACC_MAP_ID NOWAIT;
PROCEDURE delete_row (
x_LOC_ACC_MAP_ID IN NUMBER
) IS
BEGIN
DELETE FROM PN_LOC_ACC_MAP_ALL --sdm_MOAC
WHERE LOC_ACC_MAP_ID = x_LOC_ACC_MAP_ID;
END delete_row;