DBA Data[Home] [Help]

APPS.FPA_PROCESS_PVT dependencies on DBMS_AW

Line 658: dbms_aw.execute('UPDATE');

654: 'fpa.sql.FPA_Process_Pvt.Create_Pc',
655: 'Updating and Committing.'
656: );
657: END IF;
658: dbms_aw.execute('UPDATE');
659: COMMIT;
660: END IF;
661:
662: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1008: dbms_aw.execute('UPDATE');

1004: 'fpa.sql.FPA_Process_Pvt.Update_Pc',
1005: 'Updating AW and committing database.'
1006: );
1007: END IF;
1008: dbms_aw.execute('UPDATE');
1009: COMMIT;
1010: END IF;
1011:
1012: -- Detach AW Workspace

Line 1258: dbms_aw.execute('UPDATE');

1254: 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate.begin',
1255: 'Updating AW and committing database.'
1256: );
1257: END IF;
1258: dbms_aw.execute('UPDATE');
1259: COMMIT;
1260: END IF;
1261:
1262: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1539: dbms_aw.execute('UPDATE');

1535: END IF;
1536:
1537: --Update and commit our changes
1538: IF (p_commit = FND_API.G_TRUE) THEN
1539: dbms_aw.execute('UPDATE');
1540: COMMIT;
1541: END IF;
1542:
1543:

Line 1697: dbms_aw.execute('UPDATE');

1693:
1694:
1695: --Update and commit our changes
1696: IF (p_commit = FND_API.G_TRUE) THEN
1697: dbms_aw.execute('UPDATE');
1698: COMMIT;
1699: END IF;
1700:
1701: -- Finally, detach the workspace

Line 1904: dbms_aw.execute('UPDATE');

1900: END IF ;
1901:
1902: --Update and commit our changes
1903: IF (p_commit = FND_API.G_TRUE) THEN
1904: dbms_aw.execute('UPDATE');
1905: COMMIT;
1906: END IF;
1907:
1908: -- Finally, detach the workspace

Line 2429: dbms_aw.execute('UPDATE');

2425: 'Updating AW and commiting database'
2426: );
2427: END IF;
2428:
2429: dbms_aw.execute('UPDATE');
2430: COMMIT;
2431: END IF;
2432:
2433: -- Detach AW Workspace

Line 2673: dbms_aw.execute('LMT project_set_d TO ' ||l_project_set_id);

2669: );
2670: END IF;
2671:
2672: -- Update fpapjp - set portfolio project set relation
2673: dbms_aw.execute('LMT project_set_d TO ' ||l_project_set_id);
2674:
2675:
2676: for i in projectIdTbl.first .. projectIdTbl.last
2677: loop

Line 2727: dbms_aw.execute('LMT project_d TO ' || projectIdTbl(i));

2723: );
2724: END IF;
2725:
2726:
2727: dbms_aw.execute('LMT project_d TO ' || projectIdTbl(i));
2728: dbms_aw.execute('project_set_project_m = yes');
2729:
2730: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2731: FND_LOG.String

Line 2728: dbms_aw.execute('project_set_project_m = yes');

2724: END IF;
2725:
2726:
2727: dbms_aw.execute('LMT project_d TO ' || projectIdTbl(i));
2728: dbms_aw.execute('project_set_project_m = yes');
2729:
2730: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2731: FND_LOG.String
2732: (

Line 3012: dbms_aw.execute('UPDATE');

3008:
3009: -- Update and commit our changes
3010:
3011: IF (p_commit = FND_API.G_TRUE) THEN
3012: dbms_aw.execute('UPDATE');
3013: COMMIT;
3014: END IF;
3015:
3016: -- Detach AW Workspace

Line 3195: -- dbms_aw.execute('LMT project_d TO ' || projectIdTbl(i));

3191: x_msg_count => x_msg_count,
3192: x_msg_data => x_msg_data
3193: );
3194:
3195: -- dbms_aw.execute('LMT project_d TO ' || projectIdTbl(i));
3196:
3197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3198: FND_LOG.String
3199: (

Line 3289: dbms_aw.execute('UPDATE');

3285:
3286: -- Update and commit our changes
3287:
3288: IF (p_commit = FND_API.G_TRUE) THEN
3289: dbms_aw.execute('UPDATE');
3290: COMMIT;
3291: END IF;
3292:
3293: -- Detach AW Workspace

Line 3522: dbms_aw.execute('UPDATE');

3518: END IF;
3519:
3520: -- Update and commit our changes
3521: IF (p_commit = FND_API.G_TRUE) THEN
3522: dbms_aw.execute('UPDATE');
3523: COMMIT;
3524: END IF;
3525:
3526: -- Detach AW Workspace

Line 3640: dbms_aw.execute('UPDATE');

3636: END IF;
3637:
3638: -- Update and commit our changes
3639: IF (p_commit = FND_API.G_TRUE) THEN
3640: dbms_aw.execute('UPDATE');
3641: COMMIT;
3642: END IF;
3643:
3644: -- Detach AW Workspace

Line 3732: dbms_aw.execute('UPDATE');

3728: ,x_msg_data => x_msg_data);
3729:
3730: -- Update and commit our changes
3731: IF (p_commit = FND_API.G_TRUE) THEN
3732: dbms_aw.execute('UPDATE');
3733: COMMIT;
3734: END IF;
3735:
3736: -- Detach AW Workspace

Line 3837: dbms_aw.execute('UPDATE');

3833: ,x_msg_data);
3834:
3835: -- Update and commit our changes
3836: IF (p_commit = FND_API.G_TRUE) THEN
3837: dbms_aw.execute('UPDATE');
3838: COMMIT;
3839: END IF;
3840:
3841: -- Detach AW Workspace

Line 3912: dbms_aw.execute('UPDATE');

3908: );
3909:
3910: -- Update and commit our changes
3911: IF (p_commit = FND_API.G_TRUE) THEN
3912: dbms_aw.execute('UPDATE');
3913: COMMIT;
3914: END IF;
3915:
3916: -- Detach AW Workspace

Line 4269: dbms_aw.execute('UPDATE');

4265: end if;
4266:
4267: -- Update and commit our changes
4268: IF (p_commit = FND_API.G_TRUE) THEN
4269: dbms_aw.execute('UPDATE');
4270: COMMIT;
4271: END IF;
4272:
4273: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4473: dbms_aw.execute('UPDATE');

4469: END IF;
4470:
4471: -- Update and commit our changes
4472: IF (p_commit = FND_API.G_TRUE) THEN
4473: dbms_aw.execute('UPDATE');
4474: COMMIT;
4475: END IF;
4476:
4477: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4652: dbms_aw.execute('UPDATE');

4648: END IF;
4649:
4650: -- Update and commit our changes
4651: IF (p_commit = FND_API.G_TRUE) THEN
4652: dbms_aw.execute('UPDATE');
4653: COMMIT;
4654: END IF;
4655:
4656: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4916: dbms_aw.execute('UPDATE');

4912: x_msg_data => x_msg_data);
4913:
4914:
4915: if (p_commit = FND_API.G_TRUE) then
4916: dbms_aw.execute('UPDATE');
4917: COMMIT;
4918: end if;
4919:
4920: FPA_UTILITIES_PVT.Detach_AW

Line 5052: dbms_aw.execute('UPDATE');

5048: 'fpa.sql.FPA_Process_Pvt.Close_Pc',
5049: 'Updating and Committing.'
5050: );
5051: END IF;
5052: dbms_aw.execute('UPDATE');
5053: COMMIT;
5054: END IF;
5055:
5056: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 5169: dbms_aw.execute('UPDATE');

5165: );
5166:
5167: -- Update and commit our changes
5168: IF (p_commit = FND_API.G_TRUE) THEN
5169: dbms_aw.execute('UPDATE');
5170: COMMIT;
5171: END IF;
5172:
5173: -- Detach AW Workspace