APPS.GL_LEDGERS_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 3458: delete from gl_ledger_norm_seg_vals

3454:
3455: delete from gl_legal_entities_bsvs
3456: where legal_entity_id = x_le_id;
3457:
3458: delete from gl_ledger_norm_seg_vals
3459: where legal_entity_id = x_le_id
3460: and segment_type_code = 'B'
3461: and segment_value_type_code = 'S';
3462:

Line 3470: gl_ledger_norm_seg_vals where ledger_id = PLSL.ledger_id;

3466: loop
3467:
3468: BSVCount := 0;
3469: select count(*) into BSVCount from
3470: gl_ledger_norm_seg_vals where ledger_id = PLSL.ledger_id;
3471:
3472: if BSVCount = 0 then
3473: update gl_ledgers
3474: set bal_seg_value_option_code = 'A'

Line 3521: from gl_ledger_norm_seg_vals

3517: and l.bal_seg_value_set_id = lv.flex_value_set_id
3518: and l.ledger_id = cd2.object_id;
3519: CURSOR get_record_id(c_ledger_id NUMBER) IS
3520: select rowid
3521: from gl_ledger_norm_seg_vals
3522: where ledger_id = c_ledger_id
3523: and segment_type_code = 'B'
3524: and segment_value = x_bsv_value
3525: and segment_value_type_code = 'S'

Line 3529: FROM GL_LEDGER_NORM_SEG_VALS

3525: and segment_value_type_code = 'S'
3526: FOR UPDATE NOWAIT;
3527: CURSOR get_le_BSV (c_ledger_id NUMBER)IS
3528: SELECT 'has_le_bsv'
3529: FROM GL_LEDGER_NORM_SEG_VALS
3530: WHERE ledger_id = c_ledger_id
3531: AND legal_entity_id IS NOT NULL
3532: AND segment_type_code = 'B'
3533: AND segment_value_type_code = 'S'

Line 3554: GL_LEDGER_NORM_SEG_VALS_PKG.Insert_Row(

3550: EXIT WHEN get_ledger_id%NOTFOUND;
3551: OPEN get_record_id(l_ledger_id);
3552: FETCH get_record_id INTO l_rowid;
3553: IF(get_record_id%NOTFOUND AND x_operation = 'I') THEN
3554: GL_LEDGER_NORM_SEG_VALS_PKG.Insert_Row(
3555: X_Rowid => l_rowid,
3556: X_Ledger_Id => l_ledger_id,
3557: X_Segment_Type_Code => 'B',
3558: X_Segment_Value => x_bsv_value,

Line 3560: X_Record_Id => GL_LEDGER_NORM_SEG_VALS_PKG.Get_Record_Id,

3556: X_Ledger_Id => l_ledger_id,
3557: X_Segment_Type_Code => 'B',
3558: X_Segment_Value => x_bsv_value,
3559: X_Segment_Value_Type_Code => 'S',
3560: X_Record_Id => GL_LEDGER_NORM_SEG_VALS_PKG.Get_Record_Id,
3561: X_Last_Update_Date => sysdate,
3562: X_Last_Updated_By => fnd_global.user_id,
3563: X_Creation_Date => sysdate,
3564: X_Created_By => fnd_global.user_id,

Line 3585: update gl_ledger_norm_seg_vals

3581: X_Attribute13 => null,
3582: X_Attribute14 => null,
3583: X_Attribute15 => null,
3584: X_Request_Id => null);
3585: update gl_ledger_norm_seg_vals
3586: set legal_entity_id = x_le_id,
3587: last_update_date = sysdate,
3588: last_updated_by = fnd_global.user_id,
3589: last_update_login = fnd_global.login_id

Line 3645: delete from gl_ledger_norm_seg_vals

3641: and relationship_type_code in ('JOURNAL','SUBLEDGER') )
3642: and bal_seg_value_option_code = 'A';
3643: ELSIF(x_operation = 'D') THEN
3644: IF(l_completion_status <> 'CONFIRMED') THEN
3645: delete from gl_ledger_norm_seg_vals
3646: where rowid = l_rowid;
3647: OPEN get_le_BSV(l_ledger_id);
3648: FETCH get_le_BSV
3649: INTO l_has_le_bsv;

Line 3652: delete gl_ledger_norm_seg_vals

3648: FETCH get_le_BSV
3649: INTO l_has_le_bsv;
3650:
3651: IF (get_le_BSV%NOTFOUND) THEN
3652: delete gl_ledger_norm_seg_vals
3653: where ledger_id = l_ledger_id
3654: and segment_type_code = 'B'
3655: and segment_value_type_code = 'S';
3656:

Line 3674: GL_LEDGER_NORM_SEG_VALS_PKG.Delete_Row(

3670: and bal_seg_value_option_code = 'I';
3671: END IF;
3672: CLOSE get_le_BSV;
3673: ELSE
3674: GL_LEDGER_NORM_SEG_VALS_PKG.Delete_Row(
3675: X_Rowid => l_rowid);
3676: END IF;
3677: ELSIF(x_operation = 'U')THEN
3678: IF(l_completion_status <> 'CONFIRMED') THEN

Line 3679: update gl_ledger_norm_seg_vals

3675: X_Rowid => l_rowid);
3676: END IF;
3677: ELSIF(x_operation = 'U')THEN
3678: IF(l_completion_status <> 'CONFIRMED') THEN
3679: update gl_ledger_norm_seg_vals
3680: set start_date = x_start_date,
3681: end_date = x_end_date,
3682: last_update_date = sysdate,
3683: last_updated_by = fnd_global.user_id,

Line 3687: update gl_ledger_norm_seg_vals

3683: last_updated_by = fnd_global.user_id,
3684: last_update_login = fnd_global.login_id
3685: where rowid = l_rowid;
3686: ELSE
3687: update gl_ledger_norm_seg_vals
3688: set start_date = x_start_date,
3689: end_date = x_end_date,
3690: status_code = decode(status_code, 'I', 'I', 'U'),
3691: last_update_date = sysdate,