1 PACKAGE GMF_AP_GET_VENDOR_HEADER AUTHID CURRENT_USER AS
2 /* $Header: gmfvndhs.pls 120.1 2005/08/30 15:21:08 sschinch noship $ */
3
4 PROCEDURE AP_GET_VENDOR_HEADER (
5 ST_DATE IN DATE, EN_DATE IN DATE,
6 VNDRNO IN OUT NOCOPY VARCHAR2, VNDR_NAM IN OUT NOCOPY VARCHAR2,
7 VNDORID IN OUT NOCOPY NUMBER, LST_UPDT_DT OUT NOCOPY DATE,
8 LST_UPDT_BY OUT NOCOPY NUMBER, SUM_FLAG OUT NOCOPY VARCHAR2,
9 ENBL_FLAG OUT NOCOPY VARCHAR2, SEG2 OUT NOCOPY VARCHAR2,
10 SEG3 OUT NOCOPY VARCHAR2, SEG4 OUT NOCOPY VARCHAR2,
11 SEG5 OUT NOCOPY VARCHAR2, LST_UPDT_LOGIN OUT NOCOPY NUMBER,
12 CREATE_DAT OUT NOCOPY DATE, CREATE_BY OUT NOCOPY NUMBER,
13 EMP_ID OUT NOCOPY NUMBER, VNDOR_TYPE_LOOKUP_CODE OUT NOCOPY VARCHAR2,
14 CUST_NUM OUT NOCOPY VARCHAR2, SGL_TM_FLAG OUT NOCOPY VARCHAR2,
15 PARENT_VENDOR_FLAG OUT NOCOPY NUMBER, MIN_ORD_AMT OUT NOCOPY NUMBER,
16 SHIP_LOC_ID OUT NOCOPY NUMBER, BILL_LOC_ID OUT NOCOPY NUMBER,
17 SHIP_VIA_LKUP_CD OUT NOCOPY VARCHAR2, FRGHT_TERMS_LKUP_CD OUT NOCOPY VARCHAR2,
18 FOB_LKUP_CODE OUT NOCOPY VARCHAR2, TMS_ID OUT NOCOPY NUMBER,
19 SOB_ID OUT NOCOPY NUMBER, CR_STAT_LKUP_CD OUT NOCOPY VARCHAR2,
20 CR_LIM OUT NOCOPY NUMBER, AL_TK_DISC_FLAG OUT NOCOPY VARCHAR2,
21 P_DAT_LKUP_CD OUT NOCOPY VARCHAR2, P_GRP_LKUP_CD OUT NOCOPY VARCHAR2,
22 PMT_PRTY OUT NOCOPY NUMBER, INV_CURR_CD OUT NOCOPY VARCHAR2,
23 PMT_CURR_CD OUT NOCOPY VARCHAR2, INV_AMT_LIM OUT NOCOPY NUMBER,
24 EX_DAT_LKUP_CD OUT NOCOPY VARCHAR2, HLDALL_PMT_FLAG OUT NOCOPY VARCHAR2,
25 HLD_FUT_PMT_FLAG OUT NOCOPY VARCHAR2, HLD_RESN OUT NOCOPY VARCHAR2,
26 DIST_SET_ID OUT NOCOPY NUMBER, ACCTS_P_CD_COMBO_ID OUT NOCOPY NUMBER,
27 DISC_LOST_CD_COMBO_ID OUT NOCOPY NUMBER, DISC_TAKEN_CCID OUT NOCOPY NUMBER,
28 EXP_CD_COMBO_ID OUT NOCOPY NUMBER, PREPAY_CD_COMBO_ID OUT NOCOPY NUMBER,
29 N_1099 OUT NOCOPY VARCHAR2, T_1099 OUT NOCOPY VARCHAR2,
30 WTHLDG_ST_LKUP_CD OUT NOCOPY VARCHAR2, WTHLDG_START_DAT OUT NOCOPY DATE,
31 ORG_T_LKUP_CD OUT NOCOPY VARCHAR2, VAT_CD OUT NOCOPY VARCHAR2,
32 START_DAT_ACT OUT NOCOPY DATE, END_DAT_ACT OUT NOCOPY DATE,
33 QTY_RECV_TOLER OUT NOCOPY NUMBER, OVER_TOLER_ERR_FLAG OUT NOCOPY VARCHAR2,
34 MIN_GR_LKUP_CD OUT NOCOPY VARCHAR2, PMT_MTHD_LKUP_CD OUT NOCOPY VARCHAR2,
35 BK_AC_NAM OUT NOCOPY VARCHAR2, BK_AC_NUM OUT NOCOPY VARCHAR2,
36 BK_NUM OUT NOCOPY VARCHAR2, BK_AC_TYPE OUT NOCOPY VARCHAR2,
37 WOMN_OWND_FLG OUT NOCOPY VARCHAR2, SM_BUS_FLG OUT NOCOPY VARCHAR2,
38 STD_INDST_CLASS OUT NOCOPY VARCHAR2, ATTR_CATEG OUT NOCOPY VARCHAR2,
39 ATT1 OUT NOCOPY VARCHAR2, ATT2 OUT NOCOPY VARCHAR2,
40 ATT3 OUT NOCOPY VARCHAR2, ATT4 OUT NOCOPY VARCHAR2,
41 ATT5 OUT NOCOPY VARCHAR2, HLD_FLG OUT NOCOPY VARCHAR2,
42 PUR_HLD_RN OUT NOCOPY VARCHAR2, HLD_BY OUT NOCOPY NUMBER,
43 HLD_DAT OUT NOCOPY DATE, TMS_DAT_BASIS OUT NOCOPY VARCHAR2,
44 PR_TOLER OUT NOCOPY NUMBER, ROW_TO_FETCH IN OUT NOCOPY NUMBER,
45 ERROR_STATUS OUT NOCOPY NUMBER, PORG_ID IN OUT NOCOPY NUMBER);
46 END GMF_AP_GET_VENDOR_HEADER;
[Home] [Help]