2: /* $Header: jtfprefabsts.pls 120.3 2005/10/28 00:23:12 emekala ship $ */
3:
4: PROCEDURE INSERT_STATISTICS(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
3:
4: PROCEDURE INSERT_STATISTICS(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
30: );
31:
32: PROCEDURE UPDATE_STATISTICS (
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
31:
32: PROCEDURE UPDATE_STATISTICS (
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
58: );
59:
60: PROCEDURE DELETE_STATISTICS (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64:
65: p_policy_id IN NUMBER,
66: p_wsh_po_id IN NUMBER,
59:
60: PROCEDURE DELETE_STATISTICS (
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63: p_commit IN VARCHAR2 := FND_API.G_FALSE,
64:
65: p_policy_id IN NUMBER,
66: p_wsh_po_id IN NUMBER,
67:
73: );
74:
75: PROCEDURE SELECT_STATISTICS(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
74:
75: PROCEDURE SELECT_STATISTICS(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,