APPS.GL_LEDGERS_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 3429: delete from gl_ledger_norm_seg_vals

3425:
3426: -- ********************************************************************
3427: PROCEDURE remove_lgr_bsv_for_le(x_le_id NUMBER) IS
3428: BEGIN
3429: delete from gl_ledger_norm_seg_vals
3430: where legal_entity_id = x_le_id
3431: and segment_type_code = 'B'
3432: and segment_value_type_code = 'S';
3433: END remove_lgr_bsv_for_le;

Line 3464: from gl_ledger_norm_seg_vals

3460: and l.bal_seg_value_set_id = lv.flex_value_set_id
3461: and l.ledger_id = cd2.object_id;
3462: CURSOR get_record_id(c_ledger_id NUMBER) IS
3463: select rowid
3464: from gl_ledger_norm_seg_vals
3465: where ledger_id = c_ledger_id
3466: and segment_type_code = 'B'
3467: and segment_value = x_bsv_value
3468: and segment_value_type_code = 'S'

Line 3472: FROM GL_LEDGER_NORM_SEG_VALS

3468: and segment_value_type_code = 'S'
3469: FOR UPDATE NOWAIT;
3470: CURSOR get_le_BSV (c_ledger_id NUMBER)IS
3471: SELECT 'has_le_bsv'
3472: FROM GL_LEDGER_NORM_SEG_VALS
3473: WHERE ledger_id = c_ledger_id
3474: AND legal_entity_id IS NOT NULL
3475: AND segment_type_code = 'B'
3476: AND segment_value_type_code = 'S'

Line 3497: GL_LEDGER_NORM_SEG_VALS_PKG.Insert_Row(

3493: EXIT WHEN get_ledger_id%NOTFOUND;
3494: OPEN get_record_id(l_ledger_id);
3495: FETCH get_record_id INTO l_rowid;
3496: IF(get_record_id%NOTFOUND AND x_operation = 'I') THEN
3497: GL_LEDGER_NORM_SEG_VALS_PKG.Insert_Row(
3498: X_Rowid => l_rowid,
3499: X_Ledger_Id => l_ledger_id,
3500: X_Segment_Type_Code => 'B',
3501: X_Segment_Value => x_bsv_value,

Line 3503: X_Record_Id => GL_LEDGER_NORM_SEG_VALS_PKG.Get_Record_Id,

3499: X_Ledger_Id => l_ledger_id,
3500: X_Segment_Type_Code => 'B',
3501: X_Segment_Value => x_bsv_value,
3502: X_Segment_Value_Type_Code => 'S',
3503: X_Record_Id => GL_LEDGER_NORM_SEG_VALS_PKG.Get_Record_Id,
3504: X_Last_Update_Date => sysdate,
3505: X_Last_Updated_By => fnd_global.user_id,
3506: X_Creation_Date => sysdate,
3507: X_Created_By => fnd_global.user_id,

Line 3528: update gl_ledger_norm_seg_vals

3524: X_Attribute13 => null,
3525: X_Attribute14 => null,
3526: X_Attribute15 => null,
3527: X_Request_Id => null);
3528: update gl_ledger_norm_seg_vals
3529: set legal_entity_id = x_le_id,
3530: last_update_date = sysdate,
3531: last_updated_by = fnd_global.user_id,
3532: last_update_login = fnd_global.login_id

Line 3588: delete from gl_ledger_norm_seg_vals

3584: and relationship_type_code in ('JOURNAL','SUBLEDGER') )
3585: and bal_seg_value_option_code = 'A';
3586: ELSIF(x_operation = 'D') THEN
3587: IF(l_completion_status <> 'CONFIRMED') THEN
3588: delete from gl_ledger_norm_seg_vals
3589: where rowid = l_rowid;
3590: OPEN get_le_BSV(l_ledger_id);
3591: FETCH get_le_BSV
3592: INTO l_has_le_bsv;

Line 3595: delete gl_ledger_norm_seg_vals

3591: FETCH get_le_BSV
3592: INTO l_has_le_bsv;
3593:
3594: IF (get_le_BSV%NOTFOUND) THEN
3595: delete gl_ledger_norm_seg_vals
3596: where ledger_id = l_ledger_id
3597: and segment_type_code = 'B'
3598: and segment_value_type_code = 'S';
3599:

Line 3617: GL_LEDGER_NORM_SEG_VALS_PKG.Delete_Row(

3613: and bal_seg_value_option_code = 'I';
3614: END IF;
3615: CLOSE get_le_BSV;
3616: ELSE
3617: GL_LEDGER_NORM_SEG_VALS_PKG.Delete_Row(
3618: X_Rowid => l_rowid);
3619: END IF;
3620: ELSIF(x_operation = 'U')THEN
3621: IF(l_completion_status <> 'CONFIRMED') THEN

Line 3622: update gl_ledger_norm_seg_vals

3618: X_Rowid => l_rowid);
3619: END IF;
3620: ELSIF(x_operation = 'U')THEN
3621: IF(l_completion_status <> 'CONFIRMED') THEN
3622: update gl_ledger_norm_seg_vals
3623: set start_date = x_start_date,
3624: end_date = x_end_date,
3625: last_update_date = sysdate,
3626: last_updated_by = fnd_global.user_id,

Line 3630: update gl_ledger_norm_seg_vals

3626: last_updated_by = fnd_global.user_id,
3627: last_update_login = fnd_global.login_id
3628: where rowid = l_rowid;
3629: ELSE
3630: update gl_ledger_norm_seg_vals
3631: set start_date = x_start_date,
3632: end_date = x_end_date,
3633: status_code = decode(status_code, 'I', 'I', 'U'),
3634: last_update_date = sysdate,