155: ,p_last_update_login IN NUMBER
156: )
157: IS
158: l_procedure_name VARCHAR2(100) :='Insert_Row';
159: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
160: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
161: CURSOR C IS
162: SELECT
163: ROWID
156: )
157: IS
158: l_procedure_name VARCHAR2(100) :='Insert_Row';
159: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
160: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
161: CURSOR C IS
162: SELECT
163: ROWID
164: FROM
170: --log for debug
171: IF( l_proc_level >= l_dbg_level)
172: THEN
173:
174: FND_LOG.String(l_proc_level
175: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
176: ,'Enter procedure'
177: );
178:
293: --log for debug
294: IF( l_proc_level >= l_dbg_level)
295: THEN
296:
297: FND_LOG.String(l_proc_level
298: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
299: ,'Exit procedure'
300: );
301:
414: ,p_last_update_login IN NUMBER
415: )
416: IS
417: l_procedure_name VARCHAR2(100) :='Update_Row';
418: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
419: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
420: BEGIN
421:
422: --log for debug
415: )
416: IS
417: l_procedure_name VARCHAR2(100) :='Update_Row';
418: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
419: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
420: BEGIN
421:
422: --log for debug
423: IF( l_proc_level >= l_dbg_level)
422: --log for debug
423: IF( l_proc_level >= l_dbg_level)
424: THEN
425:
426: FND_LOG.String(l_proc_level
427: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
428: ,'Enter procedure'
429: );
430:
484: --log for debug
485: IF( l_proc_level >= l_dbg_level)
486: THEN
487:
488: FND_LOG.String(l_proc_level
489: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
490: ,'Exit procedure'
491: );
492:
607: ,p_last_update_login IN NUMBER
608: )
609: IS
610: l_procedure_name VARCHAR2(100) :='Lock_Row';
611: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
612: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
613:
614: CURSOR c IS
615: SELECT
608: )
609: IS
610: l_procedure_name VARCHAR2(100) :='Lock_Row';
611: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
612: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
613:
614: CURSOR c IS
615: SELECT
616: *
625: --log for debug
626: IF( l_proc_level >= l_dbg_level)
627: THEN
628:
629: FND_LOG.String(l_proc_level
630: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
631: ,'Begin procedure'
632: );
633:
964: --log for debug
965: IF( l_proc_level >= l_dbg_level)
966: THEN
967:
968: FND_LOG.String(l_proc_level
969: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
970: ,'Exit procedure'
971: );
972:
1001: (p_rowid IN OUT NOCOPY VARCHAR2
1002: )
1003: IS
1004: l_procedure_name VARCHAR2(100) :='Delete_Row';
1005: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1006: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1007: BEGIN
1008:
1009: --log for debug
1002: )
1003: IS
1004: l_procedure_name VARCHAR2(100) :='Delete_Row';
1005: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1006: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1007: BEGIN
1008:
1009: --log for debug
1010: IF( l_proc_level >= l_dbg_level)
1009: --log for debug
1010: IF( l_proc_level >= l_dbg_level)
1011: THEN
1012:
1013: FND_LOG.String(l_proc_level
1014: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1015: ,'Begin procedure'
1016: );
1017:
1030: --log for debug
1031: IF( l_proc_level >= l_dbg_level)
1032: THEN
1033:
1034: FND_LOG.String(l_proc_level
1035: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1036: ,'Exit procedure'
1037: );
1038: