APPS.PON_ACTION_HIST_PKG dependencies on PON_ACTION_HISTORY

Line 6: -- COMMENT : Table handler for PON_ACTION_HISTORY

2: -- $Header: PONHISTB.pls 120.0 2005/06/01 18:14:43 appldev noship $
3:
4: --========================================================================
5: -- PROCEDURE : InsertRowHandler PRIVATE
6: -- COMMENT : Table handler for PON_ACTION_HISTORY
7: --========================================================================
8:
9: PROCEDURE InsertRowHandler( p_OBJECT_ID IN NUMBER,
10: p_OBJECT_ID2 IN NUMBER,

Line 23: insert into PON_ACTION_HISTORY( OBJECT_ID,

19: IS
20:
21: BEGIN
22:
23: insert into PON_ACTION_HISTORY( OBJECT_ID,
24: OBJECT_ID2,
25: OBJECT_TYPE_CODE,
26: SEQUENCE_NUM,
27: ACTION_TYPE,

Line 47: -- COMMENT : Table handler for PON_ACTION_HISTORY

43:
44:
45: --========================================================================
46: -- PROCEDURE : UpdateRowHandler PRIVATE
47: -- COMMENT : Table handler for PON_ACTION_HISTORY
48: --========================================================================
49:
50: PROCEDURE UpdateRowHandler( p_OBJECT_ID IN NUMBER,
51: p_OBJECT_ID2 IN NUMBER,

Line 61: UPDATE PON_ACTION_HISTORY

57:
58: BEGIN
59:
60:
61: UPDATE PON_ACTION_HISTORY
62: SET
63: ACTION_TYPE = p_action_type,
64: ACTION_DATE = sysdate
65: WHERE OBJECT_ID = p_object_id

Line 80: -- COMMENT : Logic for determing values to insert into PON_ACTION_HISTORY

76: -- PARAMETERS: p_OBJECT_TYPE_CODE => PON_SPOTBUY for Shopping Cart.
77: -- PON_AUCTIONS for Auctions.
78: -- p_ORDER_ID => For Spot Buy => Order Header Number.
79: -- For Auctions =>
80: -- COMMENT : Logic for determing values to insert into PON_ACTION_HISTORY
81: --========================================================================
82:
83: PROCEDURE RecordHistory( p_OBJECT_ID IN NUMBER,
84: p_OBJECT_ID2 IN NUMBER,

Line 97: from PON_ACTION_HISTORY PAH

93:
94:
95: cursor chk_sequence_number(ln_objectid NUMBER, ln_objectid2 NUMBER, lv_type VARCHAR2) is
96: select max(pah.sequence_num)
97: from PON_ACTION_HISTORY PAH
98: where PAH.OBJECT_ID = ln_objectid
99: and (PAH.OBJECT_ID2 = ln_objectid2 OR PAH.OBJECT_ID2 is null)
100: and PAH.OBJECT_TYPE_CODE = lv_type;
101:

Line 111: IF (ln_seq_number >= 0) THEN -- Insert into PON_ACTION_HISTORY with the same OBJECT_IDS

107: OPEN chk_sequence_number(p_object_id, p_object_id2, p_object_type_code);
108: FETCH chk_sequence_number into ln_seq_number;
109: CLOSE chk_sequence_number;
110:
111: IF (ln_seq_number >= 0) THEN -- Insert into PON_ACTION_HISTORY with the same OBJECT_IDS
112:
113: ln_new_seq_number := ln_seq_number + 1;
114:
115: ELSE

Line 125: -- Call the RowHandler Procedure to insert a row into the table PON_ACTION_HISTORY

121:
122:
123: IF (p_continue = 'N') THEN -- We are not going to be creating two rows or updating
124:
125: -- Call the RowHandler Procedure to insert a row into the table PON_ACTION_HISTORY
126:
127: InsertRowHandler( p_OBJECT_ID => p_object_id,
128: p_OBJECT_ID2 => p_object_id2,
129: p_OBJECT_TYPE_CODE => p_object_type_code,