eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WIP_ENTITIES_UTIL dependencies on WIP_ENTITIES

Line 1: PACKAGE BODY WIP_Wip_Entities_Util AS

1: PACKAGE BODY WIP_Wip_Entities_Util AS
2: /* $Header: WIPUWENB.pls 115.7 2002/12/01 18:13:29 simishra ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Wip_Entities_Util';

2: /* $Header: WIPUWENB.pls 115.7 2002/12/01 18:13:29 simishra ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Wip_Entities_Util';
7:
8:
9: -- Function Complete_Record
10:

Line 12: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

8:
9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
13: , p_old_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
14: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;

Line 13: , p_old_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

9: -- Function Complete_Record
10:
11: FUNCTION Complete_Record
12: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
13: , p_old_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
14: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN

Line 14: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

10:
11: FUNCTION Complete_Record
12: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
13: , p_old_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
14: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN
18:

Line 16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;

12: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
13: , p_old_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
14: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN
18:
19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;

Line 19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN

15: IS
16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN
18:
19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;

16: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
17: BEGIN
18:
19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;

Line 23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

19: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

Line 24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;

20: l_Wip_Entities_rec.created_by := p_old_Wip_Entities_rec.created_by;
21: END IF;
22:
23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;

Line 27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

23: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;

24: l_Wip_Entities_rec.creation_date := p_old_Wip_Entities_rec.creation_date;
25: END IF;
26:
27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;

Line 31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

27: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;

28: l_Wip_Entities_rec.description := p_old_Wip_Entities_rec.description;
29: END IF;
30:
31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;

Line 35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

31: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;

32: l_Wip_Entities_rec.entity_type := p_old_Wip_Entities_rec.entity_type;
33: END IF;
34:
35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;

Line 39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

35: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;

36: l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
37: END IF;
38:
39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;

Line 43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

39: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;

40: l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
41: END IF;
42:
43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;

Line 47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

43: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;

44: l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
45: END IF;
46:
47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;

Line 51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

47: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;

48: l_Wip_Entities_rec.organization_id := p_old_Wip_Entities_rec.organization_id;
49: END IF;
50:
51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;

Line 55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

51: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

Line 56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;

52: l_Wip_Entities_rec.primary_item_id := p_old_Wip_Entities_rec.primary_item_id;
53: END IF;
54:
55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;

Line 59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

55: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;

56: l_Wip_Entities_rec.program_application_id := p_old_Wip_Entities_rec.program_application_id;
57: END IF;
58:
59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;

Line 63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

59: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

Line 64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;

60: l_Wip_Entities_rec.program_id := p_old_Wip_Entities_rec.program_id;
61: END IF;
62:
63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;

Line 67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

63: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;

64: l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
65: END IF;
66:
67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;

Line 71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

67: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;

68: l_Wip_Entities_rec.request_id := p_old_Wip_Entities_rec.request_id;
69: END IF;
70:
71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;

Line 75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

71: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;
77: END IF;
78:
79: RETURN l_Wip_Entities_rec;

Line 76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;

72: l_Wip_Entities_rec.wip_entity_id := p_old_Wip_Entities_rec.wip_entity_id;
73: END IF;
74:
75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;
77: END IF;
78:
79: RETURN l_Wip_Entities_rec;
80:

Line 79: RETURN l_Wip_Entities_rec;

75: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
76: l_Wip_Entities_rec.wip_entity_name := p_old_Wip_Entities_rec.wip_entity_name;
77: END IF;
78:
79: RETURN l_Wip_Entities_rec;
80:
81: END Complete_Record;
82:
83: -- Function Convert_Miss_To_Null

Line 86: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

82:
83: -- Function Convert_Miss_To_Null
84:
85: FUNCTION Convert_Miss_To_Null
86: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
87: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
88: IS
89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN

Line 87: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

83: -- Function Convert_Miss_To_Null
84:
85: FUNCTION Convert_Miss_To_Null
86: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
87: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
88: IS
89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN
91:

Line 89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;

85: FUNCTION Convert_Miss_To_Null
86: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
87: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
88: IS
89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN
91:
92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;

Line 92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN

88: IS
89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN
91:
92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 93: l_Wip_Entities_rec.created_by := NULL;

89: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type := p_Wip_Entities_rec;
90: BEGIN
91:
92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;

Line 96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN

92: IF l_Wip_Entities_rec.created_by = FND_API.G_MISS_NUM THEN
93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

Line 97: l_Wip_Entities_rec.creation_date := NULL;

93: l_Wip_Entities_rec.created_by := NULL;
94: END IF;
95:
96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;

Line 100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN

96: IF l_Wip_Entities_rec.creation_date = FND_API.G_MISS_DATE THEN
97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 101: l_Wip_Entities_rec.description := NULL;

97: l_Wip_Entities_rec.creation_date := NULL;
98: END IF;
99:
100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;

Line 104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN

100: IF l_Wip_Entities_rec.description = FND_API.G_MISS_CHAR THEN
101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 105: l_Wip_Entities_rec.entity_type := NULL;

101: l_Wip_Entities_rec.description := NULL;
102: END IF;
103:
104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;

Line 108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN

104: IF l_Wip_Entities_rec.entity_type = FND_API.G_MISS_NUM THEN
105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 109: l_Wip_Entities_rec.last_updated_by := NULL;

105: l_Wip_Entities_rec.entity_type := NULL;
106: END IF;
107:
108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;

Line 112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN

108: IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 113: l_Wip_Entities_rec.last_update_date := NULL;

109: l_Wip_Entities_rec.last_updated_by := NULL;
110: END IF;
111:
112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;

Line 116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN

112: IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 117: l_Wip_Entities_rec.last_update_login := NULL;

113: l_Wip_Entities_rec.last_update_date := NULL;
114: END IF;
115:
116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;

Line 120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN

116: IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 121: l_Wip_Entities_rec.organization_id := NULL;

117: l_Wip_Entities_rec.last_update_login := NULL;
118: END IF;
119:
120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;

Line 124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN

120: IF l_Wip_Entities_rec.organization_id = FND_API.G_MISS_NUM THEN
121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 125: l_Wip_Entities_rec.primary_item_id := NULL;

121: l_Wip_Entities_rec.organization_id := NULL;
122: END IF;
123:
124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;

Line 128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN

124: IF l_Wip_Entities_rec.primary_item_id = FND_API.G_MISS_NUM THEN
125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

Line 129: l_Wip_Entities_rec.program_application_id := NULL;

125: l_Wip_Entities_rec.primary_item_id := NULL;
126: END IF;
127:
128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;

Line 132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN

128: IF l_Wip_Entities_rec.program_application_id = FND_API.G_MISS_NUM THEN
129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 133: l_Wip_Entities_rec.program_id := NULL;

129: l_Wip_Entities_rec.program_application_id := NULL;
130: END IF;
131:
132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;

Line 136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN

132: IF l_Wip_Entities_rec.program_id = FND_API.G_MISS_NUM THEN
133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

Line 137: l_Wip_Entities_rec.program_update_date := NULL;

133: l_Wip_Entities_rec.program_id := NULL;
134: END IF;
135:
136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;

Line 140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN

136: IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 141: l_Wip_Entities_rec.request_id := NULL;

137: l_Wip_Entities_rec.program_update_date := NULL;
138: END IF;
139:
140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;

Line 144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

140: IF l_Wip_Entities_rec.request_id = FND_API.G_MISS_NUM THEN
141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 145: l_Wip_Entities_rec.wip_entity_id := NULL;

141: l_Wip_Entities_rec.request_id := NULL;
142: END IF;
143:
144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
149: l_Wip_Entities_rec.wip_entity_name := NULL;

Line 148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

144: IF l_Wip_Entities_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
149: l_Wip_Entities_rec.wip_entity_name := NULL;
150: END IF;
151:
152: RETURN l_Wip_Entities_rec;

Line 149: l_Wip_Entities_rec.wip_entity_name := NULL;

145: l_Wip_Entities_rec.wip_entity_id := NULL;
146: END IF;
147:
148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
149: l_Wip_Entities_rec.wip_entity_name := NULL;
150: END IF;
151:
152: RETURN l_Wip_Entities_rec;
153:

Line 152: RETURN l_Wip_Entities_rec;

148: IF l_Wip_Entities_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
149: l_Wip_Entities_rec.wip_entity_name := NULL;
150: END IF;
151:
152: RETURN l_Wip_Entities_rec;
153:
154: END Convert_Miss_To_Null;
155:
156: -- Procedure Update_Row

Line 159: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

155:
156: -- Procedure Update_Row
157:
158: PROCEDURE Update_Row
159: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
160: )
161: IS
162: BEGIN
163:

Line 164: UPDATE WIP_ENTITIES

160: )
161: IS
162: BEGIN
163:
164: UPDATE WIP_ENTITIES
165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type

Line 165: SET CREATED_BY = p_Wip_Entities_rec.created_by

161: IS
162: BEGIN
163:
164: UPDATE WIP_ENTITIES
165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by

Line 166: , CREATION_DATE = p_Wip_Entities_rec.creation_date

162: BEGIN
163:
164: UPDATE WIP_ENTITIES
165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date

Line 167: , DESCRIPTION = p_Wip_Entities_rec.description

163:
164: UPDATE WIP_ENTITIES
165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login

Line 168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type

164: UPDATE WIP_ENTITIES
165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id

Line 169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by

165: SET CREATED_BY = p_Wip_Entities_rec.created_by
166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id

Line 170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date

166: , CREATION_DATE = p_Wip_Entities_rec.creation_date
167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id

Line 171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login

167: , DESCRIPTION = p_Wip_Entities_rec.description
168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id

Line 172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id

168: , ENTITY_TYPE = p_Wip_Entities_rec.entity_type
169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date

Line 173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id

169: , LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id

Line 174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id

170: , LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

Line 175: , PROGRAM_ID = p_Wip_Entities_rec.program_id

171: , LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name

Line 176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date

172: , ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

Line 177: , REQUEST_ID = p_Wip_Entities_rec.request_id

173: , PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
181: ;

Line 178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

174: , PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
181: ;
182:

Line 179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name

175: , PROGRAM_ID = p_Wip_Entities_rec.program_id
176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
181: ;
182:
183: EXCEPTION

Line 180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

176: , PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
177: , REQUEST_ID = p_Wip_Entities_rec.request_id
178: , WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
179: , WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
180: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
181: ;
182:
183: EXCEPTION
184:

Line 202: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

198:
199: -- Procedure Insert_Row
200:
201: PROCEDURE Insert_Row
202: ( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
203: )
204: IS
205: BEGIN
206:

Line 207: INSERT INTO WIP_ENTITIES

203: )
204: IS
205: BEGIN
206:
207: INSERT INTO WIP_ENTITIES
208: ( CREATED_BY
209: , CREATION_DATE
210: , DESCRIPTION
211: , ENTITY_TYPE

Line 225: ( p_Wip_Entities_rec.created_by

221: , WIP_ENTITY_ID
222: , WIP_ENTITY_NAME
223: )
224: VALUES
225: ( p_Wip_Entities_rec.created_by
226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by

Line 226: , p_Wip_Entities_rec.creation_date

222: , WIP_ENTITY_NAME
223: )
224: VALUES
225: ( p_Wip_Entities_rec.created_by
226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date

Line 227: , p_Wip_Entities_rec.description

223: )
224: VALUES
225: ( p_Wip_Entities_rec.created_by
226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login

Line 228: , p_Wip_Entities_rec.entity_type

224: VALUES
225: ( p_Wip_Entities_rec.created_by
226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id

Line 229: , p_Wip_Entities_rec.last_updated_by

225: ( p_Wip_Entities_rec.created_by
226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id

Line 230: , p_Wip_Entities_rec.last_update_date

226: , p_Wip_Entities_rec.creation_date
227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id

Line 231: , p_Wip_Entities_rec.last_update_login

227: , p_Wip_Entities_rec.description
228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id

Line 232: , p_Wip_Entities_rec.organization_id

228: , p_Wip_Entities_rec.entity_type
229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date

Line 233: , p_Wip_Entities_rec.primary_item_id

229: , p_Wip_Entities_rec.last_updated_by
230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id

Line 234: , p_Wip_Entities_rec.program_application_id

230: , p_Wip_Entities_rec.last_update_date
231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id

Line 235: , p_Wip_Entities_rec.program_id

231: , p_Wip_Entities_rec.last_update_login
232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id
239: , p_Wip_Entities_rec.wip_entity_name

Line 236: , p_Wip_Entities_rec.program_update_date

232: , p_Wip_Entities_rec.organization_id
233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id
239: , p_Wip_Entities_rec.wip_entity_name
240: );

Line 237: , p_Wip_Entities_rec.request_id

233: , p_Wip_Entities_rec.primary_item_id
234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id
239: , p_Wip_Entities_rec.wip_entity_name
240: );
241:

Line 238: , p_Wip_Entities_rec.wip_entity_id

234: , p_Wip_Entities_rec.program_application_id
235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id
239: , p_Wip_Entities_rec.wip_entity_name
240: );
241:
242: EXCEPTION

Line 239: , p_Wip_Entities_rec.wip_entity_name

235: , p_Wip_Entities_rec.program_id
236: , p_Wip_Entities_rec.program_update_date
237: , p_Wip_Entities_rec.request_id
238: , p_Wip_Entities_rec.wip_entity_id
239: , p_Wip_Entities_rec.wip_entity_name
240: );
241:
242: EXCEPTION
243:

Line 266: DELETE FROM WIP_ENTITIES

262: )
263: IS
264: BEGIN
265:
266: DELETE FROM WIP_ENTITIES
267: WHERE WIP_ENTITY_ID = p_wip_entity_id
268: ;
269:
270: EXCEPTION

Line 290: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

286: -- Function Query_Row
287:
288: FUNCTION Query_Row
289: ( p_wip_entity_id IN NUMBER
290: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
291: IS
292: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
293: BEGIN
294:

Line 292: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;

288: FUNCTION Query_Row
289: ( p_wip_entity_id IN NUMBER
290: ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
291: IS
292: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
293: BEGIN
294:
295: SELECT CREATED_BY
296: , CREATION_DATE

Line 310: INTO l_Wip_Entities_rec.created_by

306: , PROGRAM_UPDATE_DATE
307: , REQUEST_ID
308: , WIP_ENTITY_ID
309: , WIP_ENTITY_NAME
310: INTO l_Wip_Entities_rec.created_by
311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by

Line 311: , l_Wip_Entities_rec.creation_date

307: , REQUEST_ID
308: , WIP_ENTITY_ID
309: , WIP_ENTITY_NAME
310: INTO l_Wip_Entities_rec.created_by
311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date

Line 312: , l_Wip_Entities_rec.description

308: , WIP_ENTITY_ID
309: , WIP_ENTITY_NAME
310: INTO l_Wip_Entities_rec.created_by
311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login

Line 313: , l_Wip_Entities_rec.entity_type

309: , WIP_ENTITY_NAME
310: INTO l_Wip_Entities_rec.created_by
311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id

Line 314: , l_Wip_Entities_rec.last_updated_by

310: INTO l_Wip_Entities_rec.created_by
311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id

Line 315: , l_Wip_Entities_rec.last_update_date

311: , l_Wip_Entities_rec.creation_date
312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id

Line 316: , l_Wip_Entities_rec.last_update_login

312: , l_Wip_Entities_rec.description
313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id

Line 317: , l_Wip_Entities_rec.organization_id

313: , l_Wip_Entities_rec.entity_type
314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date

Line 318: , l_Wip_Entities_rec.primary_item_id

314: , l_Wip_Entities_rec.last_updated_by
315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id

Line 319: , l_Wip_Entities_rec.program_application_id

315: , l_Wip_Entities_rec.last_update_date
316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id

Line 320: , l_Wip_Entities_rec.program_id

316: , l_Wip_Entities_rec.last_update_login
317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name

Line 321: , l_Wip_Entities_rec.program_update_date

317: , l_Wip_Entities_rec.organization_id
318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name
325: FROM WIP_ENTITIES

Line 322: , l_Wip_Entities_rec.request_id

318: , l_Wip_Entities_rec.primary_item_id
319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name
325: FROM WIP_ENTITIES
326: WHERE WIP_ENTITY_ID = p_wip_entity_id

Line 323: , l_Wip_Entities_rec.wip_entity_id

319: , l_Wip_Entities_rec.program_application_id
320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name
325: FROM WIP_ENTITIES
326: WHERE WIP_ENTITY_ID = p_wip_entity_id
327: ;

Line 324: , l_Wip_Entities_rec.wip_entity_name

320: , l_Wip_Entities_rec.program_id
321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name
325: FROM WIP_ENTITIES
326: WHERE WIP_ENTITY_ID = p_wip_entity_id
327: ;
328:

Line 325: FROM WIP_ENTITIES

321: , l_Wip_Entities_rec.program_update_date
322: , l_Wip_Entities_rec.request_id
323: , l_Wip_Entities_rec.wip_entity_id
324: , l_Wip_Entities_rec.wip_entity_name
325: FROM WIP_ENTITIES
326: WHERE WIP_ENTITY_ID = p_wip_entity_id
327: ;
328:
329: RETURN l_Wip_Entities_rec;

Line 329: RETURN l_Wip_Entities_rec;

325: FROM WIP_ENTITIES
326: WHERE WIP_ENTITY_ID = p_wip_entity_id
327: ;
328:
329: RETURN l_Wip_Entities_rec;
330:
331: EXCEPTION
332:
333: WHEN OTHERS THEN

Line 352: , p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type

348: --
349:
350: PROCEDURE Lock_Row
351: ( x_return_status OUT NOCOPY VARCHAR2
352: , p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
353: , x_Wip_Entities_rec OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Rec_Type
354: )
355: IS
356: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;

Line 353: , x_Wip_Entities_rec OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Rec_Type

349:
350: PROCEDURE Lock_Row
351: ( x_return_status OUT NOCOPY VARCHAR2
352: , p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
353: , x_Wip_Entities_rec OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Rec_Type
354: )
355: IS
356: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
357: BEGIN

Line 356: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;

352: , p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
353: , x_Wip_Entities_rec OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Rec_Type
354: )
355: IS
356: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
357: BEGIN
358:
359: SELECT CREATED_BY
360: , CREATION_DATE

Line 374: INTO l_Wip_Entities_rec.created_by

370: , PROGRAM_UPDATE_DATE
371: , REQUEST_ID
372: , WIP_ENTITY_ID
373: , WIP_ENTITY_NAME
374: INTO l_Wip_Entities_rec.created_by
375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by

Line 375: , l_Wip_Entities_rec.creation_date

371: , REQUEST_ID
372: , WIP_ENTITY_ID
373: , WIP_ENTITY_NAME
374: INTO l_Wip_Entities_rec.created_by
375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date

Line 376: , l_Wip_Entities_rec.description

372: , WIP_ENTITY_ID
373: , WIP_ENTITY_NAME
374: INTO l_Wip_Entities_rec.created_by
375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login

Line 377: , l_Wip_Entities_rec.entity_type

373: , WIP_ENTITY_NAME
374: INTO l_Wip_Entities_rec.created_by
375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id

Line 378: , l_Wip_Entities_rec.last_updated_by

374: INTO l_Wip_Entities_rec.created_by
375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id

Line 379: , l_Wip_Entities_rec.last_update_date

375: , l_Wip_Entities_rec.creation_date
376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id

Line 380: , l_Wip_Entities_rec.last_update_login

376: , l_Wip_Entities_rec.description
377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id

Line 381: , l_Wip_Entities_rec.organization_id

377: , l_Wip_Entities_rec.entity_type
378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date

Line 382: , l_Wip_Entities_rec.primary_item_id

378: , l_Wip_Entities_rec.last_updated_by
379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id

Line 383: , l_Wip_Entities_rec.program_application_id

379: , l_Wip_Entities_rec.last_update_date
380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id

Line 384: , l_Wip_Entities_rec.program_id

380: , l_Wip_Entities_rec.last_update_login
381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name

Line 385: , l_Wip_Entities_rec.program_update_date

381: , l_Wip_Entities_rec.organization_id
382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES

Line 386: , l_Wip_Entities_rec.request_id

382: , l_Wip_Entities_rec.primary_item_id
383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES
390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

Line 387: , l_Wip_Entities_rec.wip_entity_id

383: , l_Wip_Entities_rec.program_application_id
384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES
390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
391: FOR UPDATE NOWAIT;

Line 388: , l_Wip_Entities_rec.wip_entity_name

384: , l_Wip_Entities_rec.program_id
385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES
390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
391: FOR UPDATE NOWAIT;
392:

Line 389: FROM WIP_ENTITIES

385: , l_Wip_Entities_rec.program_update_date
386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES
390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
391: FOR UPDATE NOWAIT;
392:
393: -- Row locked. Compare IN attributes to DB attributes.

Line 390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id

386: , l_Wip_Entities_rec.request_id
387: , l_Wip_Entities_rec.wip_entity_id
388: , l_Wip_Entities_rec.wip_entity_name
389: FROM WIP_ENTITIES
390: WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
391: FOR UPDATE NOWAIT;
392:
393: -- Row locked. Compare IN attributes to DB attributes.
394:

Line 395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,

391: FOR UPDATE NOWAIT;
392:
393: -- Row locked. Compare IN attributes to DB attributes.
394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,

Line 396: l_Wip_Entities_rec.created_by)

392:
393: -- Row locked. Compare IN attributes to DB attributes.
394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)

Line 397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,

393: -- Row locked. Compare IN attributes to DB attributes.
394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,

Line 398: l_Wip_Entities_rec.creation_date)

394:
395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)

Line 399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,

395: IF WIP_GLOBALS.Equal(p_Wip_Entities_rec.created_by,
396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,

Line 400: l_Wip_Entities_rec.description)

396: l_Wip_Entities_rec.created_by)
397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)

Line 401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,

397: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.creation_date,
398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,

Line 402: l_Wip_Entities_rec.entity_type)

398: l_Wip_Entities_rec.creation_date)
399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)

Line 403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,

399: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.description,
400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,

Line 404: l_Wip_Entities_rec.last_updated_by)

400: l_Wip_Entities_rec.description)
401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)

Line 405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,

401: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.entity_type,
402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,

Line 406: l_Wip_Entities_rec.last_update_date)

402: l_Wip_Entities_rec.entity_type)
403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)

Line 407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,

403: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,

Line 408: l_Wip_Entities_rec.last_update_login)

404: l_Wip_Entities_rec.last_updated_by)
405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)

Line 409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,

405: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,

Line 410: l_Wip_Entities_rec.organization_id)

406: l_Wip_Entities_rec.last_update_date)
407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)

Line 411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,

407: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,

Line 412: l_Wip_Entities_rec.primary_item_id)

408: l_Wip_Entities_rec.last_update_login)
409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)

Line 413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,

409: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,

Line 414: l_Wip_Entities_rec.program_application_id)

410: l_Wip_Entities_rec.organization_id)
411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)

Line 415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,

411: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,

Line 416: l_Wip_Entities_rec.program_id)

412: l_Wip_Entities_rec.primary_item_id)
413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)

Line 417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,

413: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,

Line 418: l_Wip_Entities_rec.program_update_date)

414: l_Wip_Entities_rec.program_application_id)
415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)

Line 419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,

415: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,

Line 420: l_Wip_Entities_rec.request_id)

416: l_Wip_Entities_rec.program_id)
417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)

Line 421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,

417: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN

Line 422: l_Wip_Entities_rec.wip_entity_id)

418: l_Wip_Entities_rec.program_update_date)
419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN
426:

Line 423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,

419: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN
426:
427: -- Row has not changed. Set out parameter.

Line 424: l_Wip_Entities_rec.wip_entity_name)

420: l_Wip_Entities_rec.request_id)
421: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
422: l_Wip_Entities_rec.wip_entity_id)
423: AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
424: l_Wip_Entities_rec.wip_entity_name)
425: THEN
426:
427: -- Row has not changed. Set out parameter.
428:

Line 429: x_Wip_Entities_rec := l_Wip_Entities_rec;

425: THEN
426:
427: -- Row has not changed. Set out parameter.
428:
429: x_Wip_Entities_rec := l_Wip_Entities_rec;
430:
431: -- Set return status
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 434: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_SUCCESS;

430:
431: -- Set return status
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_SUCCESS;
435:
436: ELSE
437:
438: -- Row has changed by another user.

Line 441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

437:
438: -- Row has changed by another user.
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
442:
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN
445:

Line 457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

453:
454: WHEN NO_DATA_FOUND THEN
455:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461:

Line 469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;

465: END IF;
466: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
470:
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:

Line 481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

477: END IF;
478: WHEN OTHERS THEN
479:
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg

Line 494: END WIP_Wip_Entities_Util;

490:
491: END Lock_Row;
492:
493:
494: END WIP_Wip_Entities_Util;