21: PROCEDURE Process_Asset_Update_Event
22: (
23: p_event IN VARCHAR2 DEFAULT NULL
24: , p_instance_id IN NUMBER
25: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
27: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
28: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
29: );
22: (
23: p_event IN VARCHAR2 DEFAULT NULL
24: , p_instance_id IN NUMBER
25: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
27: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
28: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
29: );
30:
23: p_event IN VARCHAR2 DEFAULT NULL
24: , p_instance_id IN NUMBER
25: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
27: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
28: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
29: );
30:
31:
24: , p_instance_id IN NUMBER
25: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_last_update_date IN VARCHAR2 DEFAULT FND_API.G_MISS_DATE
27: , p_last_updated_by IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
28: , p_last_update_login IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM
29: );
30:
31:
32: /***
36: (
37: p_event IN VARCHAR2 DEFAULT NULL,
38: p_wip_entity_id IN NUMBER,
39: p_organization_id IN NUMBER DEFAULT NULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
42: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
43: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
44: );
37: p_event IN VARCHAR2 DEFAULT NULL,
38: p_wip_entity_id IN NUMBER,
39: p_organization_id IN NUMBER DEFAULT NULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
42: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
43: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
44: );
45:
38: p_wip_entity_id IN NUMBER,
39: p_organization_id IN NUMBER DEFAULT NULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
42: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
43: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
44: );
45:
46: /***
39: p_organization_id IN NUMBER DEFAULT NULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
42: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
43: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
44: );
45:
46: /***
47: ***** Proedure called when a status code is updated from User Defined Statuses form
49: PROCEDURE Process_Status_Update_Event
50: (
51: p_event IN VARCHAR2 DEFAULT NULL,
52: p_status_id IN NUMBER
53: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
55: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
56: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
57: , x_return_status IN OUT NOCOPY VARCHAR2
50: (
51: p_event IN VARCHAR2 DEFAULT NULL,
52: p_status_id IN NUMBER
53: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
55: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
56: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
57: , x_return_status IN OUT NOCOPY VARCHAR2
58: );
51: p_event IN VARCHAR2 DEFAULT NULL,
52: p_status_id IN NUMBER
53: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
55: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
56: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
57: , x_return_status IN OUT NOCOPY VARCHAR2
58: );
59:
52: p_status_id IN NUMBER
53: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: , p_last_update_date IN DATE DEFAULT FND_API.G_MISS_DATE
55: , p_last_updated_by IN NUMBER DEFAULT FND_API.G_MISS_NUM
56: , p_last_update_login IN NUMBER DEFAULT FND_API.G_MISS_NUM
57: , x_return_status IN OUT NOCOPY VARCHAR2
58: );
59:
60: /*****