[Home] [Help]
1622:
1623: l_auction_header_id Number;
1624: l_status Varchar2(30) := 'APPROVED';
1625: l_user_id Number;
1626: l_approve_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;
1627: l_approve_date_in_tz DATE;
1628: l_language_code varchar2(100);
1629: l_timezone varchar2(100);
1630: l_timezone_disp varchar2(100);
1664: itemkey => itemKey,
1665: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1666: SELECT max(action_date)
1667: INTO l_approve_date
1668: FROM pon_action_history
1669: WHERE object_id = l_auction_header_id
1670: and object_type_code = 'NEGOTIATION'
1671: and action_type = 'APPROVE';
1672:
1742: l_auction_header_id Number;
1743: l_status Varchar2(30) := 'REJECTED';
1744: l_user_id Number;
1745: l_rejection_note Varchar2(2000);
1746: l_reject_date PON_ACTION_HISTORY.ACTION_DATE%TYPE;
1747: l_reject_date_in_tz DATE;
1748: l_language_code varchar2(100);
1749: l_timezone varchar2(100);
1750: l_timezone_disp varchar2(100);
1789: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1790:
1791: SELECT max(action_date)
1792: INTO l_reject_date
1793: FROM pon_action_history
1794: WHERE object_id = l_auction_header_id
1795: and object_type_code = 'NEGOTIATION'
1796: and action_type = 'REJECT';
1797:
1917: i:=SQL%ROWCOUNT ;-- for eric test only
1918: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only
1919: end if;
1920:
1921: insert into pon_action_history
1922: (object_id,
1923: object_id2,
1924: object_type_code,
1925: sequence_num,
1965: i:=SQL%ROWCOUNT ;-- for eric test only
1966: --INSERT INTO ERIC_LOG VALUES (i ||'row(s) has been updated in pon_neg_team_members','','','','','','',''); --for eric test only
1967: END IF;
1968:
1969: INSERT INTO pon_action_history
1970: (object_id
1971: ,object_id2
1972: ,object_type_code
1973: ,sequence_num